data inversion!

[via135]

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

[Richard Buttrey]

On Sat, 6 May 2006 13:30:20 -0500, via135
<via135.27efca_1146940502.4907@excelforum-nospam.com> 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
__________________________

[via135]

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

__________________________

[Biff]

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.27efca_1146940502.4907@excelforum-nospam.com> wrote in
message news:via135.27efca_1146940502.4907@excelforum-nospam.com...
>
> 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
>

[via135]

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