Rank Ties On Another Field

I also meant to say that the Stores column will not necessarily be in descending order!

This may be a little tricky. While the stores may not be in ascending order, can we assume that the stores are grouped together (i.e. all of the store 10's are together without other stores between them)?

Pauley

@ACE_XL - that looks like it works a dream! Thanks!

@Pauley - I probably described it poorly, apologies. Each row represents a company. The first company has 11 stores, and that company made 2,400 sales. The next, separate, company has 10 stores and they made 995 sales. A third company also has 10 stores but they only made 248 sales.
I'd like the companies ranking 1 to 23 (I have a bigger table) based primarily on the amount of stores they have, but where two or more companies have the same amount of stores, then rank them on the amount of sales made.
I think ACE_XL's formula works - I still get ties when the same amount of sales are reported also - but I can probably get away with that (unless anyone know's a way round that too?!!)

Thanks for your help!

Good solution Ace_XL

Pauley

At that level, no logic.
If the amount of stores were tied and the amount of sales were tied I'd simply want one as 11th (for example) and one 12th.