Sorting by date order

J

Jock W

How can I indicate in column 'B' for instance which date entry in column 'A'
is the oldest then next oldest and so on?

For example:

A B
18/7/06 3
18/7/06 3
11/9/06 7
1/9/06 6
14/8/06 5
19/9/06 8
5/7/06 1
10/7/06 2

Is this possible?
tia
 
P

Pete_UK

Assuming your data starts in A2, enter this formula in B2:

=RANK(A2,A$2:A$9,1)

Copy the formula down.

Hope this helps.

Pete
 
Top