Hello again, guys
I'm using the following formula to rank Risks according to the value in a cell. However, right now, the formula ignores duplicates.
Let's say I have the same risk listed twice - which can happen. The formula will just ignore this and assign it the next available number. I was hoping there's some way for it take into consideration the previous number assigned to a specific risk.
This is a sample and the expected result:
Thanks!
I'm using the following formula to rank Risks according to the value in a cell. However, right now, the formula ignores duplicates.
Let's say I have the same risk listed twice - which can happen. The formula will just ignore this and assign it the next available number. I was hoping there's some way for it take into consideration the previous number assigned to a specific risk.
This is a sample and the expected result:

Thanks!
Last edited: