Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
macropod
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Weird dates appear in cells when I use Date format! Why? lizzie Excel Discussion (Misc queries) 6 June 1st 06 06:14 PM
Date and time stamping multiple cells for multiple entries. Gerald Excel Worksheet Functions 1 May 9th 06 01:45 PM
Counting Cells with certain date ranges as values audreyglennette Excel Worksheet Functions 12 May 4th 06 12:21 AM
Merging Cells when one cell is a date Patti Bowles Excel Discussion (Misc queries) 2 March 31st 05 11:15 PM
Date format of cells Alex Excel Discussion (Misc queries) 1 March 30th 05 01:47 PM


All times are GMT +1. The time now is 12:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"