G Guest Dec 5, 2003 #1 How do you flip columns upside-down (esp. where there are no trends in the numbers/data)?
M Max Dec 5, 2003 #2 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 ------------------------------------------------------- Dave said: How do you flip columns upside-down (esp. where there are no trends in the Click to expand... numbers/data)?
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 ------------------------------------------------------- Dave said: How do you flip columns upside-down (esp. where there are no trends in the Click to expand... numbers/data)?
J JMay Dec 6, 2003 #3 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 Dave said: How do you flip columns upside-down (esp. where there are no trends in the Click to expand... numbers/data)?
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 Dave said: How do you flip columns upside-down (esp. where there are no trends in the Click to expand... numbers/data)?
