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(A1:E3,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(A1:E3,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
