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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top