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.


In article ,
"Karl Espeland" wrote:

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