Re: 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 <e7#6WGuHGHA.984@xxxxxxxxxxxxxxxxxxxx>,
"Bri" <bdorr@xxxxxxxxxx> 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
.

Relevant Pages

  • Re: FEMA E-Mails
    ... but I did see it on the news. ... They showed printouts of ... the emails, too. ... Prev by Date: ...
    (rec.music.gdead)
  • WTD chipper in the N.staffs/cheshire area
    ... Ive got Mark of wolves coming from play-asia so i need my silver PS2 (old ... shape) chipping. ... Bri ... Prev by Date: ...
    (uk.games.video.playstation.forsale)
  • Re: Must be going Mad
    ... > or anyone else recall what grade you need to pass this and any last ... steve. ... Prev by Date: ...
    (microsoft.public.cert.exam.mcsa)
  • Re: tax software
    ... > The data was printed in the printouts I made at the time. ... > didn't get sent to the IRS, nor did they use the data to calculate my ... Arlington, MA ... Prev by Date: ...
    (comp.sys.mac.apps)
  • Re: tax software
    ... >> The data was printed in the printouts I made at the time. ... >> didn't get sent to the IRS, nor did they use the data to calculate my ... 30 bucks or whatever isn't my top priority at the ... Prev by Date: ...
    (comp.sys.mac.apps)