Newbie Date cells so most recent is on top

  • Thread starter Thread starter Mitymack
  • Start date Start date
M

Mitymack

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Is this possible?? 3
Most recent receipt date for an item 3
Cell Should always be the most recent Saturday 2
Finding most recently entered number within a column 3
accepting most recent date across columns 10
Determine Most/Least Frequent Date from List 2
formulas to count dates 2
Find most recent date 2

Back
Top