We play a board game called acquire (highly recommend it). We used to play tournaments with three players whose scores and rankings we kept on an excel worksheet. I used the following formula to compute the rankings: =IF(B5>C5,IF(B5>D5,1,2),IF(B5>D5,2,3)). The problem is we now have 4 players. I used the following formula, but am getting errors in some of the sceneros: =IF(B5>C5,IF(B5>D5,IF(B5>E5,1,IF(B5>D5,IF(B5>E5,2,IF(B5>E5,3,4)))))). Note it is not possible to have a tie, as we have tiebreakers in place. Help me please

You might want to look at the =RANK() function. If you have totals in B5, C5, D5 and E5

to get a ranking of the four scores you would need to enter:For cell B5: =RANK(B5,B5:E5)

For cell C5: =RANK(C5,B5:E5)

For cell D5: =RANK(D5,B5:E5)

For cell E5: =RANK(E5,B5:E5)MIKE

Awsome - worked out well, and will solve the problem if we add more players! I used to think I was pretty good at excel - guess I need to keep reading - Thanks again!!!

Ask Your Question

Weekly Poll