Excluding data from a formula if they have already been used

Hello,

I have a spreadsheet that has multiple sections where the top 4 people in a certain category are listed. What I would like to do is have a setup where a person is no longer considered for a place if he/she has already placed in something else.

For example, on the attached workbook on the statistics sheet you will see that person 1,2 and 3 each placed 1-3 respectively in Overall. On the next box, Job Specific Mill, person 1,2 and 3 also placed. I want to eliminate these 3 from this box because they have already earned a place in the box above. I want the next highest score that is not already in the top 3 of the box above it to place.

I want to disregard the 4th place

I want to have this setup for all 4 boxes on the sheet.

Thanks for any help, let me know if I need to clarify anything.

2012 Regional Scores EXAMPLE.xlsx

Anyone? Any help would be greatly appreciated!

You are exactly correct my friend

Originally Posted by daddylonglegs

Change C10 to this formula

=LARGE(IF(COUNTIF(B$3:B$5,Results!A$2:A$21)=0,Results!F$2:F$21),ROWS(C$10:C10))

confirmed with CTRL+SHIFT+ENTER and copied down to C13

B10 then needs to be changed to this

=INDEX(Results!$A$2:$A$21,SMALL(IF(Results!$F$2:$F$21=C10,IF(COUNTIF(B$3:B$5,Results!A$2:A$21)=0, ROW(Results!$F$2:$F$21)-ROW(Results!$F$2)+1)),COUNTIF(C$10:C10,C10)))

also confirmed with CTRL+SHIFT+ENTER and copied down to row 13

You can do the same for the last 2 tables, do you want those to simply ignore "Overall"?

This seems to be working. I dont want to totally ignore the overall section just the 4th place. I just dont want anyone that placed in the top 3 overall section to place again in the following sections.

It is possible that one competitor got the most overall points and did the best in "Job Specific Mill." I want this persons name to only show up in the overall.

I would like to have this same scheme as we go down. For example, If a competitor is listed in the top 3 of Overall, he or she cannot be listed in the top 3 for job specific mill or any other category below that. If someone gets first in Job Specific Mill, they cannot place in Job Specific Lathe or any category below that.

I hope this makes sense, and thank you so much for your help.