Just posted this reply below to your other thread in .misc
-------------------
This sample illustrates one way you can get it going:
http://www.freefilehosting.net/download/3b45k
Extract lines in descending order in another sht.xls

Source data in "wkly", data in cols A to C from row2 down. Lines to be
extracted in "Results", sorted in descending order by the "1st" col

In Results,
In A2: =IF(wkly!A2="","",wkly!A2-ROW()/10^10)
Leave A1 blank

In B2:
=IF(ISERROR(LARGE($A:$A,ROWS($1:1))),"",INDEX(wkly !A:A,MATCH(LARGE($A:$A,ROWS($1:1)),$A:$A,0)))
Copy B2 to D2. Select A2:D2, copy down to cover the max expected extent of
source data in "wkly". Minimize/hide away col A. Cols B to D will return the
results you seek.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jeel" wrote:
Page 1 info looks like this. I want page 2 to look like this.
Page 1 is named WKLY. Page 2 is named results.
A B C A B C
1 1st# 2nd# name 1st# 2nd# name
2 340 352 mike 362 432 bob
3 340 641 tom 358 516 joe
4 358 516 joe 340 641 mike
5 362 432 bob 340 352 tom

I am working in groups of 4.
I used the formula =LARGE(wkly!$A$2:$A$5,1) to move column a
info to page 2 but I also wanted column b and c. Max posted the following
formula which worked fine until I came to the duplicates.
=INDEX(wkly!a$2:a$5,MATCH(LARGE(wkly!$a$2:$a$5,ROW S($1:1)),wkly!
$a$2:$a$5,0))
Max posted me another formula but I can't seem to make it work. Any help
would be appreciated. I hope this example makes sense. Also, in my first
formula the 1 on the end won't update to 2,3,4 as I drag it down. Would
it help
to add another number column or use a different formula to move column a?
Thanks, jeel.