I think that's the one

do a pivot table.

Man, every time I read one of these posts, I realize just how many people in this world are a hell of a lot smarter than me.

Hey, I just realize how happy I am being old and decrepit. I do not have to worry about setting up a table like this in excel.

I am a supervisor at a manufacturing plant in Irving and work the graveyard shift. Been here 31 years and nothing at this place challenges my abilities anymore

RANK function should do the trick.

I ended up using this bad boy

=INDEX($B$3:$B$200,MATCH(1,INDEX(($K$3:$K$200=LARGE($K$3:$K$200,ROWS(N$2:N2)))*(COUNTIF(N$2:N2,$B$3:$B$200)=0),),0))

Tldr

lol