| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Date for Sorting | Excel Discussion (Misc queries) | |||
| Sorting date and non "date" | Excel Discussion (Misc queries) | |||
| Sorting By Date | Excel Discussion (Misc queries) | |||
| re-arrange data in date order | Excel Worksheet Functions | |||
| What formulas are best for sorting by date? | Excel Worksheet Functions | |||
Linear Mode
