rearranging data

Hi,

I have some columns in excel were I want to rearrange the data so that

1
3
2
4

becomes

4
2
3
1

How do I do that?

regards,
Kbka

On what basis do you want to re-arrange the data? Its not very clear with the example you have provided.

Originally Posted by arlu1201

On what basis do you want to re-arrange the data? Its not very clear with the example you have provided.

Simply by the order... I want the first number to be the last, the second to be the second last, the third to be the third from last etc.

Originally Posted by arlu1201

On what basis do you want to re-arrange the data? Its not very clear with the example you have provided.

What I need is to take a column and "Turn it upside down"

Assuming your data is in row A1 to A5 put the formula

Please Login or Register  to view this content.

in
cells B1 to B5.

Then you sort your date in range A1 to B5 by selecting "Sort by" colum B and "Decending"

Alf

OP is from Denmark so formula should be:

=INDEX($A$1:$A$100; COUNT(A1:A100))

Alf