Next to your stores' scores, use a helper column (I'll assume C) with this
formula:
=RANK(B2,B$2:B$10)

Then, to get the stores in descending order, you can do:
=INDEX(A$2:A$10,MATCH(ROW(A1),C:C,0)

--
Best Regards,

Luke M
"YS1107" wrote in message
...
I need a tiebreaker for a formula. Right now the formula reads:
=INDEX(A$3:A$21,MATCH(D28,Y$3:Y$21,0)) which works real well But when
there
is a tie it shows on one store twice instead of listing the two separate
stores. I have two stores have the exact scores and it list the store with
the lower store number twice. For example I have store 598 and store 698
both
with a score of 100% but in the ranking of the stores it shows store 598
twice instead of 598 then 698. Is it possible to have a tiebreaker, with
the
index formula, that can list the stores in descending order, 598 first and
698 second, or do I need another formula in order for the tiebreaker to
work?

Here is what it looks like now:

C28 D28
598 100%
598 100%

I need it to look like this

C28 D28
598 100%
698 100%

If this is not possible I can live without the tiebreaker, I suppose. :)
Thanks