Max to min for dates
 

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?

Max to min for dates
 

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

"LiAD" wrote in message
...
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?

Max to min for dates
 

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