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