Here are some problems that our users have asked and received explanations on
My rank formula is not working =IFERROR(RANK(C4,C24:H24,0),"") please help
Solved by K. J. in 20 mins
Pivot table rank in excel 2013 is not correct
Solved by A. S. in 13 mins
rank formula .......................................
Solved by T. J. in 14 mins
I NEED FORMULA TO FIND LOWEST RANK FOR EACH NAME
Solved by T. A. in 11 mins
I cannot enter this formula into Excel. I get an error message asking for an apostrophe?IF($S2=0,"",IF($S2>0,RANK($S2,$S$2:$S$8000),RANK($S2,$S$2:$S$8000-COUNTIF($S$2:$S$8000,0)))