Hi Howard,
Am Tue, 24 Feb 2015 21:31:56 -0800 (PST) schrieb L. Howard:
=SUM(IF(FREQUENCY(A1:INDEX(F:F,G1),A1:INDEX(F:F,G1 )),1))
try:
=SUM(1/COUNTIF(INDIRECT("A1:F"&G1),INDIRECT("A1:F"&G1)))
=SUM(IF(FREQUENCY(INDIRECT("A1:F"&G1),INDIRECT("A1 :F"&G1))0,1))
Regards
Claus B.
Ahh! That looks like it! The ref_text is in double quotes and the cell
ref will be appended as text. This is the same syntax as
Range("A1:F"&G1) where the row value is stored in G1! Without the
double quotes I suspect XL is wanting a range name...
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion