Reversing the contents of a List without programming

[Karl Espeland]

Hi,

I have a spread sheet with a set of values in a column. I need to represent
these values in the reverse order. (Think of data that first are
representeted in chronological order, but that needs to be represented in
reverse chronological order as well).

Is there a good way of achieving this whithout programming and without maual
sorting?

thanks and Merry Christmas

 

[JE McGimpsey]

One way:

Assume your data is in column A, with no blank cells. Then enter

B1: =INDEX(A:A,COUNTA(A:A)-ROW()+1)

and copy down as far as the data in column A.

 

[Frank Kabel]

Hi
and another solution
in B1 enter 1, in B2 enter 2. Now select both cells and copy down for all
rows. After this sort your data with column B descending