Flip Cells
 

Wondering how to take info in a number of rows and flip the rows so that row
100 is now row 1 and row 1 has row 100s information. Not sure if a macro
would be better (don't know the code) or is there a simple excel function
that does this.

Flip Cells
 

Simplist way would be


Insert a column to the left of your list.
in the first cell of the column put the number 1
In the second cell put the number 2
drag this dow for all 100 rows

do a sort on the new list (including the new column) and sort on the first
column descending.



"Tim" wrote:

Wondering how to take info in a number of rows and flip the rows so that row
100 is now row 1 and row 1 has row 100s information. Not sure if a macro
would be better (don't know the code) or is there a simple excel function
that does this.

Flip Cells
 

Hi
in a helper cell in B1 enter the formula
=OFFSET($A$100,-(ROW()-1),0)
and copy this down
Afterwards copy this column and use 'Edit - Paste Special - Values' to
remove the formulas

--
Regards
Frank Kabel
Frankfurt, Germany
"Tim" schrieb im Newsbeitrag
...
Wondering how to take info in a number of rows and flip the rows so that
row
100 is now row 1 and row 1 has row 100s information. Not sure if a macro
would be better (don't know the code) or is there a simple excel function
that does this.