Sorting by date order
Thanks for feeding back.
Pete
Jock W wrote:
Thanks very much Pete. Job done.
--
Jock Waddington
"Pete_UK" wrote:
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
Jock W wrote:
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
--
Jock Waddington
|