Ranking System/Formula Issues

Easy answer, put them in a pivot and sorty by the value, or just sort the base list

You can use this formula to get the ranking (and accommodate ties) - I put it in J2 of your file:

=RANK(C2,$C$2:$C$121)+COUNTIF(C$2:C2,C2)-1

Then you can use this formula to retrieve the breed in K2:

=INDEX(B:B,MATCH(ROWS($1:1),$J:$J,0))

and you can copy this into L2 to get the number.

Copy the formulae down to row 121.

Hope this helps.

Pete

Originally Posted by FerdyHar

I changed the formula in G2 to:

Formula:

Please Login or Register  to view this content.

Formula in E2

Formula:

Please Login or Register  to view this content.

Not touched the F column, as I'm not that into creating lists yet, but this should give you a more accurate ranking.

Ferdy

Thank you Ferdy, this worked beautifully. I've only had a cursory look but will delve deeper as time allows to understand what difference your changes made.

Originally Posted by Pete_UK

You can use this formula to get the ranking (and accommodate ties) - I put it in J2 of your file:

=RANK(C2,$C$2:$C$121)+COUNTIF(C$2:C2,C2)-1

Then you can use this formula to retrieve the breed in K2:

=INDEX(B:B,MATCH(ROWS($1:1),$J:$J,0))

and you can copy this into L2 to get the number.

Copy the formulae down to row 121.

Hope this helps.

Pete

Thank you Pete, I will have a look at your solution too and rep if helpful. Appreciated.