I am trying to do a unique sum of records using this code:
SUM(IF(FREQUENCY(IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""), IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""))>0,1))
It works great, BUT I want to add in one more condition to see that the unique records have a matching field C=4 in the records C2:C10. How do I do this?
Thanks alot!!!
J
SUM(IF(FREQUENCY(IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""), IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""))>0,1))
It works great, BUT I want to add in one more condition to see that the unique records have a matching field C=4 in the records C2:C10. How do I do this?
Thanks alot!!!
J