olimajor123
Board Regular
- Joined
- Nov 13, 2013
- Messages
- 72
Hi,
I have a sum product forumla I am using as there is no RANKIF function in excel. The current formula I have is <bdo dir="ltr">
=1+sumproduct(($B$2:$B$119=B2)*($AQ$2:$AQ$119>AQ2))
This is where column B is a players position and column AQ is the amount of goals they have scored. The rank ranks players on how many goals they've scored by position and it works however if you have two people on the same amount it ranks them as the same value. I want to add onto the formula that it then ranks them by alphabetical order so there are not two players with the same rank value. The names of the players is in column C.
Can anyone help please?
</bdo>
I have a sum product forumla I am using as there is no RANKIF function in excel. The current formula I have is <bdo dir="ltr">
=1+sumproduct(($B$2:$B$119=B2)*($AQ$2:$AQ$119>AQ2))
This is where column B is a players position and column AQ is the amount of goals they have scored. The rank ranks players on how many goals they've scored by position and it works however if you have two people on the same amount it ranks them as the same value. I want to add onto the formula that it then ranks them by alphabetical order so there are not two players with the same rank value. The names of the players is in column C.
Can anyone help please?
</bdo>
