data inversion!
 

hi!

how can i make the data, say, in the first 3 rows
gets inverted..may be in another area of the sheet.?

hlp pl?

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=539557

data inversion!
 

On Sat, 6 May 2006 13:30:20 -0500, via135
wrote:


hi!

how can i make the data, say, in the first 3 rows
gets inverted..may be in another area of the sheet.?

hlp pl?

-via135


If I've understood your requirement, one way would be to use a helper
column and number the rows 1,2 & 3. then sort the data including the
helper column with a descending operator. Then if required, Copy (or
cut) and paste to wherever you want.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

data inversion!
 

Hi!

Suppose your data is in the range A1:E3 and looks like this:

1;2;3;4;5
2;3;4;5;6
3;4;5;6;7

And you want:

3;4;5;6;7
2;3;4;5;6
1;2;3;4;5

=INDEX($A$1:$E$3,3+1-ROWS($1:1),COLUMNS($A:A))

Copy across then down.

Biff

"via135" wrote in
message ...

hi!

how can i make the data, say, in the first 3 rows
gets inverted..may be in another area of the sheet.?

hlp pl?

-via135


--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=539557

data inversion!
 

thks Richard!
good idea!!

-via135


If I've understood your requirement, one way would be to use a helper
column and number the rows 1,2 & 3. then sort the data including the
helper column with a descending operator. Then if required, Copy (or
cut) and paste to wherever you want.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=539557

data inversion!
 

thks Biff!
this is what I exactly wanted!!

-via135


Hi!

Suppose your data is in the range A1:E3 and looks like this:

1;2;3;4;5
2;3;4;5;6
3;4;5;6;7

And you want:

3;4;5;6;7
2;3;4;5;6
1;2;3;4;5

=INDEX($A$1:$E$3,3+1-ROWS($1:1),COLUMNS($A:A))

Copy across then down.

Biff


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=539557