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.

I can think of one way. introduce another column <index and type 1 and fill
upto 100 down.
sort the data range with this column -descending

may be easier sollutions available.


Buckaluckawuk wrote in message
...
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.

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)


On Tue, 8 Feb 2005 19:01:02 -0800, "Buckaluckawuk"
wrote:

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.

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


On Tue, 8 Feb 2005 19:01:02 -0800, "Buckaluckawuk"
wrote:

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.