Reversing Cells

Originally Posted by Warrior01

Hi,

I have a list of numbers that goes from cell "b2" down to "b700". I would like "b700" to be at the top and "b2" at the bottom. Can this be done?

Thanks.

Try this in any other column.

=INDIRECT("B"&ROW($A$701)-ROW(A1)) and copy it down.