Help with pool league

Dear friend,

I run a pool billiards league where I rank the players according to games won followed by winning percentage as per the attached spreadsheet.

I would like to change the formulae to first record the highest percentage of games won PROVIDING the player has played a minimum of games... say 10.

Can you help?

AttachmentSize
week 13 stats league singles.xls73.5 KB

simplest way

Hi Mikthai,

Just add the following formula in H4:

=IF(D4>=10,1,0)

then copy down. Sort on Column H, then Column G, then Column E, from largest to smallest. This will put everyone who has played at least 10 games above every other player, but ranking both types in order of win % then games won.

Regards
Mark