I can't seem to make the formula work. Colomn a returned the right answer.
Colomn B gave me 0, or num error. Column c gave me n/a error. Does it make
a difference if I'm using Vista and Excel 2007? Thank you. jeel

"Teethless mama" wrote:

correction should be:
A2: =LARGE(First,ROWS($1:1))

"Teethless mama" wrote:

"First", "Second", and "name" are defined name ranges (no quotes)

In A2: =LARGE(First,ROWS($1:2))
copy down

In B2: =LARGE(IF(First=A2,Second),COUNTIF($A$2:A2,A2))
ctrl+shift+enter, not just enter
copy down

In C3: =INDEX(name,MATCH(1,(First=A2)*(Second=B2),0))
ctrl+shift+enter, not just enter
copy down


"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.