| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Move first 12 ranked rows to another area
I have an excel sheet with rank formula used in column F. i want pick up
first 12 ranked rows (entire cells from Column A to Column F) and copied into column J to column L. Any speedy help will be highly appreciated. Thanks in Advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Move first 12 ranked rows to another area
You could record a macro while you copy the ranked column F and 'paste
special' the values into column J You could then use the macro (with a command button) whenever needed. -- Traa Dy Liooar Jock "vijaydsk1970" wrote: I have an excel sheet with rank formula used in column F. i want pick up first 12 ranked rows (entire cells from Column A to Column F) and copied into column J to column L. Any speedy help will be highly appreciated. Thanks in Advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Move first 12 ranked rows to another area
One play using non-array formulas which delivers the full* auto-sort of the
source range by the rankings (covers possibility of tied/duplicate rankings as well) .. *just pick off the top xx as desired Illustrated in this sample construct: http://www.savefile.com/files/1012446 Auto Sorted Range by Rank.xls Assume source range in A2:F20, data from row2 down, with key col F = rank In I2: =IF(F2="","",F2+ROW()/10^10) Leave I1 blank In J2: =IF(ROWS($1:1)COUNT($I:$I),"",INDEX(A:A,MATCH(SMA LL($I:$I,ROWS($1:1)),$I:$I,0))) Copy J2 to O2. Select I1:O2, copy down. Cols J to O will return a full auto-sort of the source range (sorted by rank col F, ascending). Lines with tied/duplicate rankings, if any, will appear in the same relative order that they are within the source. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "vijaydsk1970" wrote: I have an excel sheet with rank formula used in column F. i want pick up first 12 ranked rows (entire cells from Column A to Column F) and copied into column J to column L. Any speedy help will be highly appreciated. Thanks in Advance |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Move first 12 ranked rows to another area
Speechless with delight as usual ? <g
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Move first 12 ranked rows to another area
Sorry Max,
I have not worked the solution till today. Any how it is working nice. Thanks for your time spared. "Max" wrote: Speechless with delight as usual ? <g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Move first 12 ranked rows to another area
Max can you give me your mail ?
"vijaydsk1970" wrote: Sorry Max, I have not worked the solution till today. Any how it is working nice. Thanks for your time spared. "Max" wrote: Speechless with delight as usual ? <g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Move first 12 ranked rows to another area
"vijaydsk1970" wrote
Sorry Max, I have not worked the solution till today. Any how it is working nice. Thanks for your time spared. welcome. good to hear that. Max can you give me your mail ? Why ? -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Move first 12 ranked rows to another area
To distrub you with your permission if require
"Max" wrote: "vijaydsk1970" wrote Sorry Max, I have not worked the solution till today. Any how it is working nice. Thanks for your time spared. welcome. good to hear that. Max can you give me your mail ? Why ? -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Move first 12 ranked rows to another area
Pl keep all discussions within the newsgroup for the benefit of all.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "vijaydsk1970" wrote in message ... To distrub you with your permission if require |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you delete all hidden columns in an area in one move? | Excel Discussion (Misc queries) | |||
| Area Chart need to move y axes data on the other side | Excel Discussion (Misc queries) | |||
| I click on a cell and move the cursor the entire area highlights | Excel Discussion (Misc queries) | |||
| I click on a cell and move the cursor the entire area highlights . | Excel Discussion (Misc queries) | |||
| How do I move the Category Axis labels outside of the Plot Area? | Charts and Charting in Excel | |||
Linear Mode
