TheJonWithNoH
New Member
- Joined
- Sep 8, 2017
- Messages
- 30
Hello,
I am trying to rank values from largest to smallest between two sets of dates but running into some issues. The dates are in column B and I am trying to rank the numbers in column H and the ranking is in Column J.
This is the formula that I am currently using:
=IFERROR(IF(MONTH(B2)=MONTH(Setup!$H$14),(RANK.EQ(H2,$H$2:$H$10000,0)+COUNTIF(H2:H$10000,H2)-1),""),"")
The only issue that I am running into here is for example if I am trying to rank the values for December, some ranking will not show up because the values are in another month. How can I get the "Value if False" to show the next ranking?
Hope I am making sense here.
Thank you in advance for help!
JB
I am trying to rank values from largest to smallest between two sets of dates but running into some issues. The dates are in column B and I am trying to rank the numbers in column H and the ranking is in Column J.
This is the formula that I am currently using:
=IFERROR(IF(MONTH(B2)=MONTH(Setup!$H$14),(RANK.EQ(H2,$H$2:$H$10000,0)+COUNTIF(H2:H$10000,H2)-1),""),"")
The only issue that I am running into here is for example if I am trying to rank the values for December, some ranking will not show up because the values are in another month. How can I get the "Value if False" to show the next ranking?
Hope I am making sense here.
Thank you in advance for help!
JB