Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |