Both formulas return the number of unique values in the range.
Say the formulas are in H1 and H2.
{=SUM(1/COUNTIF(A1:F5,A1:F5))}
=SUM(IF(FREQUENCY(A1:F5,A1:F5)0,1))
With the value 3 in cell G1, how can I make either/both of these
formulas change F5 to F3.
So, vary the range from A1 to F? by the value in G1.
Thanks.
Howard
Take a look at the INDIRECT() function...
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion