Ranking with multi conditions

Hi guys,

Need your help with a ranking formula.

Im trying to rank the order of these names so that:

• If person started within 12 month = NO, then
• the person with the most "Closed Orders" is # 1
• If person started within 12 month = YES then
• the person with the most "Closed Orders" is ranked first BUT is of lower ranking than all the people is "no" for started within 12 months

.
Ignore "NO DATE"


This formula is the only thing i can think of, but the numbers are consecutive.

Formula:

Please Login or Register  to view this content.

Any ideas on how i can make this consecutive?

Thanks in advance for your time

Hi Richard,

You are right, rank YES & NO people separately. Then move the YES people to the bottom of the list.

I actually got it to work. Thank you!

You gave me such an obvious solution, added another column and rank based my not-consecutive ranking.

It is now consecutive.

Thanks you!