Reversing the contents of a List without programming
 

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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

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