Need help with format

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
 
T

Tom Ogilvy

=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.
 
Top