Put 1 to 10 in the 10 cells next to it, select all the data and sort in descending order on the
helper column. Then just delete the 1 to 10.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"mark" wrote in message ...
Is there a functional way to flip a column of data. So
that if I have 10 numbers in range A1:A10, the number in
cell A10 would then be at the top of the column, and the
number that was originally in A1 would be at the bottom.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003