J
jeel
The first page looks like this. I want page 2 to look like this. On page 2
Results
Page 1 is named WKLY. Page 2 is named Results. I used
LARGE 1, etc
A B C A B C
1 1st# 2nd# name 1st# 2nd# name The cell A2
formula is
2 340 352 mike 362 432 bob
=LARGE(wkly!$A$2:$A$5,1)
3 340 641 tom 358 516 joe etc 2,3,4. I
received a formula
4 358 516 joe 340 352 mike from Max to
make the info
5 362 432 bob 340 641 tom match in
columns b & c.
=INDEX(wkly!a$2:a$5,MATCH(LARGE(wkly!$a$2:$a$5,ROWS($1:1)),wkly!$a$2:$a$5,0))
This worked well except for the duplicates. I received another formula from
Max but I can't seem to make that work. Any help would be appreciated. I hope
this example makes sense. Thanks, jeel.
Results
Page 1 is named WKLY. Page 2 is named Results. I used
LARGE 1, etc
A B C A B C
1 1st# 2nd# name 1st# 2nd# name The cell A2
formula is
2 340 352 mike 362 432 bob
=LARGE(wkly!$A$2:$A$5,1)
3 340 641 tom 358 516 joe etc 2,3,4. I
received a formula
4 358 516 joe 340 352 mike from Max to
make the info
5 362 432 bob 340 641 tom match in
columns b & c.
=INDEX(wkly!a$2:a$5,MATCH(LARGE(wkly!$a$2:$a$5,ROWS($1:1)),wkly!$a$2:$a$5,0))
This worked well except for the duplicates. I received another formula from
Max but I can't seem to make that work. Any help would be appreciated. I hope
this example makes sense. Thanks, jeel.