Rank on multiple variables

[lauramitchell]

Hi

Pretty please could someone help with this! I have been working on it for hours. :-S I am trying to rank items based on certain criteria. For example, in the below, I want to rank the rows based on the type of game and turnover. I've completed them manually below. Any ideas anyone?

Rank number in group	Game	Turnover
1	Baccarat	100
2	Baccarat	10
3	Baccarat	14
2	Blackjack	600
1	Blackjack	700
2	Cards	45
1	Cards	97

<tbody>
</tbody>

 

[barry houdini]

Hello lauramitchell, welcome to MrExcel

Assuming you have Games in column B and Turnover in column C then try this formula in row 2 copied down for the ranking

=COUNTIFS(B:B,B2,C:C,">"&C2)+1

Assumes Excel 2007 or later version