Sad to report that the information I am trying to rank is spread across
more than one column.

Right now Im using this formula:

=SUMPRODUCT(--(A:A=A4),--(N4<B:B))+1

.... can this be modified to take into account C:C, D:D, and E:E, so
that A4 is ranked out of the results of all of those columns?

S Davis wrote:
Thanks, will do!
-S

wrote:
Hello,

Search for Bernie's function Rankif in this newsgroup.

HTH,
Bernd