I am attempting to count unique entries in a worksheet across several ranges. I used the cpearson formula of
=SUM(IF(FREQUENCY(IF(LEN($K$4:$K$31)>0,MATCH($K$4:$K$31,$K$4:$K$31,0),""),IF(LEN($K$4:$K$31)>0,MATCH($K$4:$K$31,$K$4:$K$31,0),""))>0,1))
and that works fine. But I need to look at C4:C17 and C26:C43 at the same time to cound unique values. Can someone help me with what the formula should look like?
TIA
chastst
=SUM(IF(FREQUENCY(IF(LEN($K$4:$K$31)>0,MATCH($K$4:$K$31,$K$4:$K$31,0),""),IF(LEN($K$4:$K$31)>0,MATCH($K$4:$K$31,$K$4:$K$31,0),""))>0,1))
and that works fine. But I need to look at C4:C17 and C26:C43 at the same time to cound unique values. Can someone help me with what the formula should look like?
TIA
chastst