Flip Columns Upside-Down?

[Dave]

How do you flip columns upside-down (esp. where there are no trends in the numbers/data)?

 

[Max]

Try:

Fill an adjacent helper column with running numbers (1,2,3,...)
down as many rows as that present in the target column

Select both helper & target columns
Sort by the helper column > Descending > OK

--
hth
Max
-----------------------------------------
Please reply in thread

Use xdemechanik <at>yahoo<dot>com for email
-------------------------------------------------------

How do you flip columns upside-down (esp. where there are no trends in the

numbers/data)?

 

[JMay]

If your Column Info is in A6 through A100, in a Helper Column say Cell B6
enter:
=OFFSET($A$6,COUNT(A6:$A$100)-1,0) and Copy down to B100.
HTH

How do you flip columns upside-down (esp. where there are no trends in the

numbers/data)?