how to flip a column upside down

W

winglj

Hi, everyone. I have a question about fliping the datas in one column
upside down in excell? Any functions or Macro can do it? thanks
 
D

Dave Peterson

Maybe you can use a helper column.

Put 1, 2, 3, 4, ... all the way down that column.

Then select your data and sort by this column in descending order.

Then delete the helper column.
 
C

CLR

If they are sorted in Ascending order, just select one cell and click on the
"Sort Descending" button in the toolbar., or do Sort > and follow the menu
for sorting descending.

Vaya con Dios,
Chuck, CABGx3
 
J

Jim May

For a Macro solution In a standard module paste in:

Option Explicit
Option Base 1

'You must First Highlight or Select the cells you
'want to Flip before running this Macro

Sub FlipCells() 'Works only if Cells contain Numbers
Dim MyNum() As Long
Dim cell As Range
Dim Rng As Range
Dim MyCount As Long
Dim i As Long
Dim j As Long
Dim k As Long
Set Rng = Selection
MyCount = Rng.Rows.Count
ReDim MyNum(MyCount)
For i = 1 To MyCount
MyNum(i) = Rng(i).Value
Next i
k = 1
For j = MyCount To 1 Step -1
Rng(k).Value = MyNum(j)
k = k + 1
Next j
End Sub

Hope this helps
Jim May
 
J

Jim May

Sorry - I failed to Highlight that my suggestion only works
if your data is numbers - You indicated dates (which are numbers, so it
should work for you).
 
Top