Sorting by date order
 

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

Sorting by date order
 

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

Sorting by date order
 

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

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