Help with cell reference

Y

YS1107

I need help with cell reference in cells. In cells A3:A21 I have a list of
store numbers and in cells Y3:Y21 I have scores. In cells D28:D32 I have the
top 5 stores scores. I have figured out to get the top 5 scores to populate
in cells D28:D32 by using the LARGE function =LARGE($Y$3:$Y$21,1). Now I need
the have the stores numbers to populate in cells C28:C32 next to the scores
in D28:D32. I have tried several formulas to get this to work with success.
VLOOKUP,INDEX/MATCH. I need some help and direction.
 
Y

YS1107

Now is there a way to break a tie? as of now it shows on one store twice
instead of listing the two seperate stores. I made two stores have the exact
scores and it list the store with the lower 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. And if this is
possible can we have it list it in descending order? 598 first and 698
second? 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 for your HELP BOB!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top