This is just a small portion of my spreadsheet, it's fairly large, so I did a Snip-IT.
There are 23 cells that I want ranked 1-23, with any duplicate values ranking with different numbers, so there are no 2 #3s or "3.5" or 3 #6s as my snipit shows. For this example, cells EH14, EO14, EV14, FC14 - I need the Rank to value where it doesn't do duplicates. So EH14 should be 4, EO14 should be 5, EV14 should be 6, and FC14 should be 7. The cells to rank are the values under "TA" which are EN13, EU13, FB13, and FI13. If you need the other "3.5" cells, they are EA14 and EG13.
I have tried these formulas to no avail. For some reason, the beginning of the spreadsheet I did the first formula and it worked fine, but when I started adding more people, all the people at the end started showing the .5 or duplicate numbers. Can't figure that out either but if I can get the right formula, hopefully that won't matter.
Thanks in advance for any help/direction you can give me.
=RANK.AVG(EN13,(K$13,R$13,Y$13,AF$13,AM$13,AT$13,BA$13,BH$13,BO$13,BV$13,CC$13,CJ$13,CQ$13,CX$13,DE$13,DL$13,DS$13,DZ$13,EG$13,EN$13,EU$13,FB$13,FI$13))
=RANK.AVG(EN13,(K$13,R$13,Y$13,AF$13,AM$13,AT$13,BA$13,BH$13,BO$13,BV$13,CC$13,CJ$13,CQ$13,CX$13,DE$13,DL$13,DS$13,DZ$13,EG$13,EN$13,EU$13,FB$13,FI$13))+COUNTIF($$EN$13:EN13,EN13)-1
=RANK.EQ(EU13,($K$13,$R$13,$Y$13,$AF$13,$AM$13,$AT$13,$BA$13,$BH$13,$BO$13,$BV$13,$CC$13,$CJ$13,$CQ$13,$CX$13,$DE$13,$DL$13,$DS$13,$DZ$13,$EG$13,$EN$13,$EU$13,$FB$13,$FI$13))+COUNTIF($EU$13:EU13,EU13)-1
There are 23 cells that I want ranked 1-23, with any duplicate values ranking with different numbers, so there are no 2 #3s or "3.5" or 3 #6s as my snipit shows. For this example, cells EH14, EO14, EV14, FC14 - I need the Rank to value where it doesn't do duplicates. So EH14 should be 4, EO14 should be 5, EV14 should be 6, and FC14 should be 7. The cells to rank are the values under "TA" which are EN13, EU13, FB13, and FI13. If you need the other "3.5" cells, they are EA14 and EG13.
I have tried these formulas to no avail. For some reason, the beginning of the spreadsheet I did the first formula and it worked fine, but when I started adding more people, all the people at the end started showing the .5 or duplicate numbers. Can't figure that out either but if I can get the right formula, hopefully that won't matter.
Thanks in advance for any help/direction you can give me.
=RANK.AVG(EN13,(K$13,R$13,Y$13,AF$13,AM$13,AT$13,BA$13,BH$13,BO$13,BV$13,CC$13,CJ$13,CQ$13,CX$13,DE$13,DL$13,DS$13,DZ$13,EG$13,EN$13,EU$13,FB$13,FI$13))
=RANK.AVG(EN13,(K$13,R$13,Y$13,AF$13,AM$13,AT$13,BA$13,BH$13,BO$13,BV$13,CC$13,CJ$13,CQ$13,CX$13,DE$13,DL$13,DS$13,DZ$13,EG$13,EN$13,EU$13,FB$13,FI$13))+COUNTIF($$EN$13:EN13,EN13)-1
=RANK.EQ(EU13,($K$13,$R$13,$Y$13,$AF$13,$AM$13,$AT$13,$BA$13,$BH$13,$BO$13,$BV$13,$CC$13,$CJ$13,$CQ$13,$CX$13,$DE$13,$DL$13,$DS$13,$DZ$13,$EG$13,$EN$13,$EU$13,$FB$13,$FI$13))+COUNTIF($EU$13:EU13,EU13)-1