placing.. 1st, 2nd, 3rd...

  • Thread starter Thread starter fivermsg
  • Start date Start date
F

fivermsg

I have a data table with total points b2:b17. I am trying to make a
ranking system to read the points and distinguish 1st through 6th
place.. this is the formula that i am using
=INDEX(A2:A13,MATCH(LARGE(B2:B13,4),B2:B13,0))
but when i use this I am getting the same name when two people have the
same total... Any suggestions?
 
You must log in or register to reply here.

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

Similar Threads

can this be fixed to find for next name 1
Data Validation question 1
Excel Formula's 6
Comparing 2 cells using vlookup 4
change the formula by changing contents of cell 4
Ranking Lists 3
1st smallest, 2nd smallest,3rd smallest 6
Sorting Data in a Row Question 5

Back
Top