Max to min for dates

[LiAD]

Hi,

If I have a list of names, codes and dates such as; (can be in any order)

A FRED 15/3/09 06:00
B BILL 16/3/09 07:00
A BEN 18/3/09 04:00
D DAVE 18/3/09 06:00
A ED 18/3/09 02:00
B WIL 15/3/09 01:00

From this I would like to rank the dates min to max for one category so that
my outputs would be arranged with the lowest date and time first for each
category, stretching up to the longest date and time at the end.

A

FRED 15/3/09 06:00
ED 18/3/09 02:00
BEN 18/3/09 04:00

B
WIL 15/3/09 01:00
BILL 16/3/09 07:00

Any thoughts on how best to do this?

 

[Ashish Mathur]

Hi,

In a separate column use the formula A2&C2 and copy down. Now sort on this
new column (in ascending order).

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Bernd P]

Hello,

Or sort it this way:
http://www.sulprobil.com/html/sort_vba.html

Or this way:
http://www.sulprobil.com/html/sorting.html

Regards,
Bernd