A
allie357
I have 2 columns of values (numbers that contain text values). I need
to count the unique numbers in the one column if the column next to it
contains a null value.
I am using this formula to count the unique values (array formula) but
I only want it to calculate if the value in the corresponding cell is
null.
Please help.
=SUM(IF(FREQUENCY(IF(LEN(D23130)>0,MATCH(D23130,D23130,0),""), IF
(LEN(D23130)>0,MATCH(D23130,D23130,0),""))>0,1))
to count the unique numbers in the one column if the column next to it
contains a null value.
I am using this formula to count the unique values (array formula) but
I only want it to calculate if the value in the corresponding cell is
null.
Please help.
=SUM(IF(FREQUENCY(IF(LEN(D23130)>0,MATCH(D23130,D23130,0),""), IF
(LEN(D23130)>0,MATCH(D23130,D23130,0),""))>0,1))