Ranking a list
Actually, the formula shouldn't return FALSE. Make sure that you
include...
,"")
....at the end of the formula. Just to be sure, here's the formula
again...
=IF(A1<"",SUM(IF($A$1:$A$5<"",IF(A1<$A$1:$A$5,
1/COUNTIF($A$1:$A$5,$A$1:$A$5))))+1,"")
....which should be entered all on the same line.
In article ,
"Bri" wrote:
Domenic
This works perfectly! However, it prints FALSE in the blank cells that
don't get a ranking. Do you know of a way to suppress this? (Printouts of
the results will be distributed, so it would be better if the word FALSE
wasn't seen)
Thanks, Bri
|