data inversion!

V

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
 
R

Richard Buttrey

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
Click to expand...


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
__________________________
 
B

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
 
V

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
Click to expand...
__________________________
 
Top