Thread: Count unique values in one column if values in corresponding columnare null?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
allie357[_2_] allie357[_2_] is offline
external usenet poster
  
Posts: 5
Default Count unique values in one column if values in corresponding columnare null?
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(D2:D3130)0,MATCH(D2:D313 0,D2:D3130,0),""), IF
(LEN(D2:D3130)0,MATCH(D2:D3130,D2:D3130,0),""))0 ,1))
Reply With QuoteReply With Quote