Rank Order by Min Values

Ian Bell
Ian Bell used Ask the Experts™
on
Hi,
I would like to rank values by minimum order.
Please see attached
many thanks
Ian
Rank-Order-by-min-value.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can use this formula
=COUNTIFS($A$2:$A$17,A2,$B$2:$B$17,"<"&B2)+1
Rank-Order-by-min-value.xlsx
Ian Bellretired

Author

Commented:
Thanks Ejgil, it works a treat.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial