Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I invert a column's contents
I have several columns of data and the data is listed upside down. SO, I
want to change it so the last line is first and the first line is last and all the lines/rows in between are inverted as well. I know there's a simple way to do this in excel but I don't know how. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I invert a column's contents
As a work around until someone tells you the "proper" way to do this:
How about temporarily adding a column, inserting numbers 1 - 10 (or whatever number of rows you wish to sort), sort in reverse numerical order and then delete the extra column? -- Rae Drysdale "Todd" wrote: I have several columns of data and the data is listed upside down. SO, I want to change it so the last line is first and the first line is last and all the lines/rows in between are inverted as well. I know there's a simple way to do this in excel but I don't know how. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I invert a column's contents
One way ... using a formula:
=INDEX($A$1:$A$20,20-(ROW(A1)-1)) And copy down. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Todd" wrote in message ... I have several columns of data and the data is listed upside down. SO, I want to change it so the last line is first and the first line is last and all the lines/rows in between are inverted as well. I know there's a simple way to do this in excel but I don't know how. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine several columns into a single column | Excel Discussion (Misc queries) | |||
compare contents of two adjacent columns | Excel Worksheet Functions | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |