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