D
David
Starting with (1) SUMPRODUCT((Rng<>"")/COUNTIF(Rng,Rng&""))
I am trying (and failing) to count uniques (always values) greater than a
specified value
ie a combination of SUMPRODUCT(--(Rng>=4)) and (1)
Any advice will be most appreciated
I am trying (and failing) to count uniques (always values) greater than a
specified value
ie a combination of SUMPRODUCT(--(Rng>=4)) and (1)
Any advice will be most appreciated