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.