Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reversing a column. How?
How do I reverse the order of items in a column? I have a column of
50 numbers. How do I create a new column of numbers so that the first number in the new column is the last number in the old column and the last number of the new column is the first number in the old column? Is there an easy way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reversing a column. How?
=INDEX($A$1:$A$50,51-ROW())
Copy down -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message .. . | How do I reverse the order of items in a column? I have a column of | 50 numbers. How do I create a new column of numbers so that the first | number in the new column is the last number in the old column and the | last number of the new column is the first number in the old column? | Is there an easy way to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reversing a column. How?
go to a blank column, starting at the top, enter the address of the last cell
on your list, if it's column a, you would type A50, below that, type A49. Now, highlight those two cells, and use the Fill Handle (the square in the lower right corner of the bottom cell) and drag it down, you shoule end up with a column of A50, A49, A48, etc. Now, lets say the column you just made was B, use the formula =INDIRECT(B1,1) and copy that formula down. That's the best I could come up with? " wrote: How do I reverse the order of items in a column? I have a column of 50 numbers. How do I create a new column of numbers so that the first number in the new column is the last number in the old column and the last number of the new column is the first number in the old column? Is there an easy way to do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reversing a column. How?
VERY clever Niek..........it led me to this little modification.......
=IF(A1<"",INDEX($A$1:$A$50,COUNTA(A:A)+1-ROW()),"") Vaya con Dios, Chuck, CABGx3 "Niek Otten" wrote: =INDEX($A$1:$A$50,51-ROW()) Copy down -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message .. . | How do I reverse the order of items in a column? I have a column of | 50 numbers. How do I create a new column of numbers so that the first | number in the new column is the last number in the old column and the | last number of the new column is the first number in the old column? | Is there an easy way to do this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reversing a column. How?
You could use =(OFFSET(A$1,50-ROW(),0)) in row 1, and copy that down.
-- David Biddulph wrote in message .. . How do I reverse the order of items in a column? I have a column of 50 numbers. How do I create a new column of numbers so that the first number in the new column is the last number in the old column and the last number of the new column is the first number in the old column? Is there an easy way to do this? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reversing a column. How?
You guys are way smarter than me.
:) "David Biddulph" wrote: You could use =(OFFSET(A$1,50-ROW(),0)) in row 1, and copy that down. -- David Biddulph wrote in message .. . How do I reverse the order of items in a column? I have a column of 50 numbers. How do I create a new column of numbers so that the first number in the new column is the last number in the old column and the last number of the new column is the first number in the old column? Is there an easy way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |