Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Newbie Date cells so most recent is on top
Trying to create a better spreadsheet, is there a way to reverse the
entries so the most recent date or input appears on the top of the page instead of the bottom. Thank you for any help you can give. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Newbie Date cells so most recent is on top
Hi Mitymack,
If you number the existing rows (eg using autofill) using a temporary column, then sort the sheet using this column as the sort key, with the sort order set to 'descending' the data order will be reversed. Cheers wrote in message ps.com... Trying to create a better spreadsheet, is there a way to reverse the entries so the most recent date or input appears on the top of the page instead of the bottom. Thank you for any help you can give. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weird dates appear in cells when I use Date format! Why? | Excel Discussion (Misc queries) | |||
Date and time stamping multiple cells for multiple entries. | Excel Worksheet Functions | |||
Counting Cells with certain date ranges as values | Excel Worksheet Functions | |||
Merging Cells when one cell is a date | Excel Discussion (Misc queries) | |||
Date format of cells | Excel Discussion (Misc queries) |