How do I flip a column in excel (top becomes bottom)?

[Buckaluckawuk]

This seeems like it should be a simple thing to do but I can't make it
happen. I have a column of 100's of data points. I want to check they
symmetry of the data across the center point, so I want to compare the
original column to an flipped version of the same data and look at the
differences between these columns. The problem comes when I'm trying to flip
the column.... I can't figure out how.

I'm using Excel 2003 if that helps.

 

[Myrna Larson]

You can make a copy of the data and sort it as suggested, or you can generate
that new column with formulas. You need to know what the last row number is.
Say it's 958

=OFFSET($A$1,958-ROW(),0)

 

[Gord Dibben]

A VBA mthod from David McRitchie.......

Sub ReversI()
'David McRitchie 1998-07-30 documented in
' http://www.mvps.org/dmcritchie/excel/join.htm
'Reverse (Flip) Item values in Range, Row, or Column
'Counting in multiple rows/cols, item count proceeds down a
'column in range and continues top of next column in range
Dim tcells As Long, mCells As Long, ix As Long, ox As Long
Dim iValue As Variant
tcells = Selection.Count
mCells = tcells / 2
For ix = 1 To mCells
iValue = Selection.item(ix).Value
ox = tcells + 1 - ix
Selection.item(ix).Value = Selection.item(ox).Value
Selection.item(ox).Value = iValue
Next ix
End Sub

Select the range and run the macro.


Gord Dibben Excel MVP