software

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: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=539557On Sat, 6 May 2006 13:30:20 -0500, via135
gt; wrote:

gt;
gt;hi!
gt;
gt;how can i make the data, say, in the first 3 rows
gt;gets inverted..may be in another area of the sheet.?
gt;
gt;hlp pl?
gt;
gt;-via135If I've understood your requirement, one way would be to use a helper
column and number the rows 1,2 amp; 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
__________________________

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

quot;via135quot; gt; wrote in
message ...
gt;
gt; hi!
gt;
gt; how can i make the data, say, in the first 3 rows
gt; gets inverted..may be in another area of the sheet.?
gt;
gt; hlp pl?
gt;
gt; -via135
gt;
gt;
gt; --
gt; via135
gt; ------------------------------------------------------------------------
gt; via135's Profile:
gt; www.excelforum.com/member.php...oamp;userid=26725
gt; View this thread: www.excelforum.com/showthread...hreadid=539557
gt;

thks Richard!
good idea!!

-via135gt; If I've understood your requirement, one way would be to use a helper
gt; column and number the rows 1,2 amp; 3. then sort the data including the
gt; helper column with a descending operator. Then if required, Copy (or
gt; cut) and paste to wherever you want.
gt;
gt; HTH
gt; __
gt; Richard Buttrey
gt; Grappenhall, Cheshire, UK
__________________________--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=539557
thks Biff!
this is what I exactly wanted!!

-via135gt; Hi!
gt;
gt; Suppose your data is in the range A1:E3 and looks like this:
gt;
gt; 1;2;3;4;5
gt; 2;3;4;5;6
gt; 3;4;5;6;7
gt;
gt; And you want:
gt;
gt; 3;4;5;6;7
gt; 2;3;4;5;6
gt; 1;2;3;4;5
gt;
gt; =INDEX($A$1:$E$3,3 1-ROWS($1:1),COLUMNS($A:A))
gt;
gt; Copy across then down.
gt;
gt; Biff--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=539557