Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invert data order
I am trying to flip the data that i have in a column. I don't want them in
ascendent order or descendent order. I just want the bottom data to be at the top and the top data to be at the bottom. Any suggestions? Thanks a lot. Ibone |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invert data order
let's say we have data in A1 thru A30. In an un-used column enter:
=INDIRECT("A" & 31-ROW()) and copy down. Then take the helper column, copy it, and paste/special/value back onto column A -- Gary's Student gsnu200704 "Ibone" wrote: I am trying to flip the data that i have in a column. I don't want them in ascendent order or descendent order. I just want the bottom data to be at the top and the top data to be at the bottom. Any suggestions? Thanks a lot. Ibone |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invert data order
=INDEX($A$2:$A$100,ROWS($A$2:$A$100)-ROWS($1:1)+1)
"Ibone" wrote: I am trying to flip the data that i have in a column. I don't want them in ascendent order or descendent order. I just want the bottom data to be at the top and the top data to be at the bottom. Any suggestions? Thanks a lot. Ibone |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invert data order
put in a helper column
enter 1,2 in the column to the end of the data Select the two columns and sort on the helper column desending delete the helper column "Ibone" wrote: I am trying to flip the data that i have in a column. I don't want them in ascendent order or descendent order. I just want the bottom data to be at the top and the top data to be at the bottom. Any suggestions? Thanks a lot. Ibone |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |