Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Reverse Data from bottom to top
I want to reverse the whole spreadsheet, e.g. data of July at the bottom (1st
July) has to go to the top and August data (31st August) should be at the bottom, as against what is in my sheet |
#2
|
|||
|
|||
Select the data you want to sort and then go to the data menu. Select sort
and it will ask you by which column you would like to sort. Select the one with the date and select ascending or descending. It should automatically sort it for you correctly. "Joman" wrote: I want to reverse the whole spreadsheet, e.g. data of July at the bottom (1st July) has to go to the top and August data (31st August) should be at the bottom, as against what is in my sheet |
#3
|
|||
|
|||
Hi!
If you have a column of true Excel dates just select the data you want inverted and sort on the date column ascending. Biff "Joman" wrote in message ... I want to reverse the whole spreadsheet, e.g. data of July at the bottom (1st July) has to go to the top and August data (31st August) should be at the bottom, as against what is in my sheet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
How do I quickly reverse the order of a set of data | Excel Discussion (Misc queries) | |||
DATA VALIDATION IN REVERSE #2 (FOR JULIE D.) | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |