S
Sean
I received the following formula which counts the number of unique
occurences within my Range "Range1" but I'm getting a #N/A error, yet
when I go into the formula edit, it shows me a result of 16, which is
correct
Why would this be (BTW it has worked correcly for 8 weeks)
{=SUM(IF(FREQUENCY(IF(LEN(Range1)>0,MATCH(Range1,Range1,0),""),IF(LEN(Range1)>0,MATCH(Range1,Range1,0),""))>0,1))}
occurences within my Range "Range1" but I'm getting a #N/A error, yet
when I go into the formula edit, it shows me a result of 16, which is
correct
Why would this be (BTW it has worked correcly for 8 weeks)
{=SUM(IF(FREQUENCY(IF(LEN(Range1)>0,MATCH(Range1,Range1,0),""),IF(LEN(Range1)>0,MATCH(Range1,Range1,0),""))>0,1))}