Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rearranging cronological data.
I have a set of 25,000 row wind data that I just want to flip so the last
entry is first and the first is last. I have some crazy dates that don't match up in the data so I would like to be able to keep the order of everything now without sorting it by date. Im using 07. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rearranging cronological data.
I'd insert a column and and put in a list from 1 to 25,000 and sort on that.
In older versions of xl it was Edit, fill, series, Step Value 1, Stop Value 25000 and click OK if it does not work enter the first number yourself. Peter "Gatorman" wrote: I have a set of 25,000 row wind data that I just want to flip so the last entry is first and the first is last. I have some crazy dates that don't match up in the data so I would like to be able to keep the order of everything now without sorting it by date. Im using 07. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rearranging data | Excel Discussion (Misc queries) | |||
rearranging data | Excel Worksheet Functions | |||
Rearranging Data in Excel | Excel Discussion (Misc queries) | |||
Rearranging the layout of data | Excel Discussion (Misc queries) | |||
Rearranging Data Help... | Excel Discussion (Misc queries) |