G
Guest
I use following array formula to count unique values in range:
=SUM(IF(FREQUENCY(IF(LEN(P7679)>0;MATCH(P7679;P7679;0);"");
IF(LEN(P7679)>0;MATCH(P7679;P7679;0);""))>0;1))
IT works well if P7679 contains simple entered values, but returns N/A
error if cells have their own formulas. In my case in range P7679 i have
formula:
=IF($L76=1;HLOOKUP("Summa";INDIRECT(res.table);$M76);"")
which works perfectly well and returns following values:
P
76 "k"
77 "k"
78 "" <- (blank text)
79 "" <- (blank text)
I can't understand why does unique values formula fail to return value 1.
It does not fail if i replace formulas with their values (by copy, paste
values only) e.g
If range conain simple values unique value counter work's well, but if range
contains formulas it returns N/A eroor
How can i solve this problem ?
=SUM(IF(FREQUENCY(IF(LEN(P7679)>0;MATCH(P7679;P7679;0);"");
IF(LEN(P7679)>0;MATCH(P7679;P7679;0);""))>0;1))
IT works well if P7679 contains simple entered values, but returns N/A
error if cells have their own formulas. In my case in range P7679 i have
formula:
=IF($L76=1;HLOOKUP("Summa";INDIRECT(res.table);$M76);"")
which works perfectly well and returns following values:
P
76 "k"
77 "k"
78 "" <- (blank text)
79 "" <- (blank text)
I can't understand why does unique values formula fail to return value 1.
It does not fail if i replace formulas with their values (by copy, paste
values only) e.g
If range conain simple values unique value counter work's well, but if range
contains formulas it returns N/A eroor
How can i solve this problem ?