Need help with format

  • Thread starter Thread starter R2ri
  • Start date Start date
R

R2ri

I have 2,000 players in football pool game. What would
be a format I'd use. How will I be able to find the
player with the least amount of mistakes?

Thanks,
R2ri
 
=Index(A:A,Match(min(B:B),B:B,0),1)

Assume names are in column A, count of mistakes in column B

if there is a tie for least amount, the player in the lowest numbered row
with the least amount will be shown.

Also look in Excel Help for the RANK function.
 
Back
Top