Forum Discussion
listing items in ranked order
willowbe Must admit that not reading a question properly can create problems. I've now created a work-around by introducing a helper column. In this column a unique ranking number, a fraction lower than the real one, is calculated. This will make my original formula work as it was planned to. Have a look at the attached workbook.
Until you become an Insider, I believe the following will do the trick.
=INDEX($A$2:$A$10,(MATCH(LARGE($B$2:$B$10,ROW()-ROW($B$1)),$B$2:$B$10,0)))
Read more about the Insider program here:
Riny_van_Eekelen Hmmm, this seems to get me part of the way there, but it returns just the highest then the next highest, and so on, rather than all of the items with the highest score, followed by all of the items with the next highest, etc. Also, it returns each item three times in a row.... In other words, instead of:
1 Fish
2 Whale
3 Cat
4 Horse
5 Shark
6 Bird
7 Sheep
8
9
10
I am getting:
1 Fish
2 Fish
3 Fish
4 Cat
5 Cat
6 Cat
7 Bird
8 Bird
9 Bird
10 Duck
etc.
Have I done something wrong?
Thanks so much!
willowbe Must admit that not reading a question properly can create problems. I've now created a work-around by introducing a helper column. In this column a unique ranking number, a fraction lower than the real one, is calculated. This will make my original formula work as it was planned to. Have a look at the attached workbook.
Riny_van_Eekelen YES that works! Thank you!!
willowbe Ooops. My fault. Hadn't seen that you had multiple animals with the same score.