Is there an easy way to "mirror" data in excel ?

e.g.
Let's say I have the following values in one row
1 2 3 4 5

I would like to make it
5 4 3 2 1

I tried using =[cell_number] in a separate row and did a control+R,
but it did not pick it up correctly.

Any ideas on how to do this?


Mahurshi Akilla

I assume that the actual data are not sorted in ascending order.
You can use the sort option though by inserting a help row with numbers
1,2,3,4,5,6,7,etc
Highlight both rows and sort by the helper row <descending.

Go into the sort options at the bottom to select sort from left to right.
--
Greetings from New Zealand

"Mahurshi Akilla" wrote in message
ups.com...
Is there an easy way to "mirror" data in excel ?

e.g.
Let's say I have the following values in one row
1 2 3 4 5

I would like to make it
5 4 3 2 1

I tried using =[cell_number] in a separate row and did a control+R,
but it did not pick it up correctly.

Any ideas on how to do this?


Mahurshi Akilla

Another play ..
Assume source data in A1:E1
Put in A2: =OFFSET($E$1,,-COLUMNS($A:A)+1)
Copy A2 to E2. A2:E2 will return the mirror inversion of A1:E1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mahurshi Akilla" wrote:
Is there an easy way to "mirror" data in excel ?

e.g.
Let's say I have the following values in one row
1 2 3 4 5

I would like to make it
5 4 3 2 1

I tried using =[cell_number] in a separate row and did a control+R,
but it did not pick it up correctly.

Any ideas on how to do this?


Mahurshi Akilla

Non-volatile approach:

=INDEX(1:1,1+COUNTA(1:1)-COLUMNS($A:A))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Mahurshi Akilla" wrote in message
ups.com...
Is there an easy way to "mirror" data in excel ?

e.g.
Let's say I have the following values in one row
1 2 3 4 5

I would like to make it
5 4 3 2 1

I tried using =[cell_number] in a separate row and did a control+R,
but it did not pick it up correctly.

Any ideas on how to do this?


Mahurshi Akilla