Rank Problem

[Andrew C]

Hi

I have a sheet of tenpin bowlers with the scratch averages
worked out from their scores bowled. Not all bowlers
completed all the games.

I want to rank the bowlers in order of average but with
those who completed all the games get ranked first and
those who didnt get ranked last.

example

Jack 184 ave 10 games
Harry 164 ave 10 games
Andrew 156 ave 8 games
Terry 190 Ave 10 games
Kevin 200 ave 8 games

In this exmample i need Terry to get a ranked 1st followed
by jack then,harry, kevin and then Andrew last

Can someone help with a solution

Thanks

Andrew

 

[Arvi Laanemets]

Hi

Add a (hidden) column
=Score+1000*(Games=10)

You get a table
Jack 184 1184 10
Harry 164 1164 10
Andrew 156 156 8
Terry 190 1190 10
Kevin 200 200 8

Now you can made your ranking easily

 

[Daniel.M]

Hi,

With your score in B1:B5 and your #games in C1:C5, the following formula in E1:

=1+SUMPRODUCT(--(10000*C$1:C$5+B$1:B$5>10000*C1+B1))

Copy to E2:E5

Regards,

Daniel M.