Thread: Ranking a list
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default 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