

CountIF 
Offset Check 
+ Small No 
VLOOKUP 
Large 
Name 
1 
Harmon 
=IF(D2>1,0,COUNTIF(B:B,B2)) 
=COUNTIF(OFFSET($B$2,0,0,A2,1),B2) 
=C2+A2/1000 
=B2 
=LARGE($E$2:$E$10,A2) 
=VLOOKUP(G2,$E$2:$F$10,2,0) 
2 
Smith 
=IF(D3>1,0,COUNTIF(B:B,B3)) 
=COUNTIF(OFFSET($B$2,0,0,A3,1),B3) 
=C3+A3/1000 
=B3 
=LARGE($E$2:$E$10,A3) 
=VLOOKUP(G3,$E$2:$F$10,2,0) 
3 
Smith 
=IF(D4>1,0,COUNTIF(B:B,B4)) 
=COUNTIF(OFFSET($B$2,0,0,A4,1),B4) 
=C4+A4/1000 
=B4 
=LARGE($E$2:$E$10,A4) 
=VLOOKUP(G4,$E$2:$F$10,2,0) 
4 
Harmon 
=IF(D5>1,0,COUNTIF(B:B,B5)) 
=COUNTIF(OFFSET($B$2,0,0,A5,1),B5) 
=C5+A5/1000 
=B5 
=LARGE($E$2:$E$10,A5) 
=VLOOKUP(G5,$E$2:$F$10,2,0) 
5 
Williams 
=IF(D6>1,0,COUNTIF(B:B,B6)) 
=COUNTIF(OFFSET($B$2,0,0,A6,1),B6) 
=C6+A6/1000 
=B6 
=LARGE($E$2:$E$10,A6) 
=VLOOKUP(G6,$E$2:$F$10,2,0) 
6 
Williams 
=IF(D7>1,0,COUNTIF(B:B,B7)) 
=COUNTIF(OFFSET($B$2,0,0,A7,1),B7) 
=C7+A7/1000 
=B7 
=LARGE($E$2:$E$10,A7) 
=VLOOKUP(G7,$E$2:$F$10,2,0) 
7 
Smith 
=IF(D8>1,0,COUNTIF(B:B,B8)) 
=COUNTIF(OFFSET($B$2,0,0,A8,1),B8) 
=C8+A8/1000 
=B8 
=LARGE($E$2:$E$10,A8) 
=VLOOKUP(G8,$E$2:$F$10,2,0) 
8 
Williams 
=IF(D9>1,0,COUNTIF(B:B,B9)) 
=COUNTIF(OFFSET($B$2,0,0,A9,1),B9) 
=C9+A9/1000 
=B9 
=LARGE($E$2:$E$10,A9) 
=VLOOKUP(G9,$E$2:$F$10,2,0) 
9 
Williams 
=IF(D10>1,0,COUNTIF(B:B,B10)) 
=COUNTIF(OFFSET($B$2,0,0,A10,1),B10) 
=C10+A10/1000 
=B10 
=LARGE($E$2:$E$10,A10) 
=VLOOKUP(G10,$E$2:$F$10,2,0) 
Like this thread? Share it with others