If your numbers start in A1,
In B1 enter 1,
And in B2 enter 2.
Then, select both cells and double click on the "drag handle" (little black
square in lower right corner of selection).
If there are no empty cells in Column A, you will fill column B with a list
of numerically ordered numbers, as far as there is data in Column A.
If you have empty cells in Column A, then simply click on the drag handle
and drag down as far as necessary to fill Column B.
Now, select *both* Column A and B, and sort on Column B *descending*.
This will "flip" your data in Column A.
While the two columns are still selected, right click in the selection and
choose "Copy", and then navigate to where ever you would like the "flipped"
data to reside, right click in the upper left "starter" cell, and then paste
it there.
You can now go back and re-select Column A and B, and again sort on Column
B, but choose *ascending*, which will return Column A to it's original
order.
You can now delete the "helper" columns of numbers.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
Say you want to just flip the data fieldin one column into a different
column, basically flip the data without sorting any of the values,EX 12
578654
123584 1233584
578654 12
example but for hundreds of different variables
Thanks in advance
