On Sat, 27 Aug 2005 14:48:41 -0400, "Biff" wrote:
=MIN(1,COUNTIF(H5:L5,"=" &$F$1) - COUNTIF(H5:L5,"" &$H$1))
Hmmm...
If that works then so should:
=IF(SUMPRODUCT(--(MOD(COLUMN(H5:L5),2)=0),--(H5:L5=F1),--(H5:L5<=H1)),1,0)
I was accounting for the non-contiguous range and the possibilty of other
numeric data within the range, but even if you leave that out:
=IF(SUMPRODUCT(--(H5:L5=F1),--(H5:L5<=H1)),1,0)
That should also work.
I don't get it!
When Pe66les posted the variation of *my* formula that he actually tried, it
was incorrect. Perhaps the same thing was going on with the translation of
yours.
--ron
|