Ok I don't know if this is the right place or if I have the right title but I hope I can describe this so you understand
Total brain freeze here!!
Below is the way the summary page for the scores looks after doing functions to fine the top scores and placing them in the grid from 8 other worksheets. What I need it to do now is to put the school and Name of student in the middle 2 columns based on the score. So who whoever has the 12.04 for example will take that school name and put it in column 2 and the students name and put it in column 3. As you can see there are 2 scores that tied so I need to get the school and student for those to fill in too.
I'm trying to do this with a formula if possible
Place.......School.......Name.......Score
1...........................................12.04
1...........................................12.04
3...........................................12.00
4...........................................11.04
5...........................................11.03
6...........................................11.00
7...........................................10.40
Bookmarks