Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 __________________________ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |