Counting unique values

[Tencijup]

Hi,

I would really appreciate if you could help me.
I am trying to count the unique values in a column based on possible duplicate entries in another column. I apologize for not being able to attach a file/picture of the data but it look like this.
A1 = "Customer"
A2:A9 has values: A,A,B,C,D,E,E,F
B1= "Exclusion flags"
B2:B9 has the value ("YES") only in B2 and B4. The rest of the B column is blank.
I am trying to count the number of flags in the B column based on possible duplicates in col A. I am having a really hard time as the duplicate values in col A may be either flagged "YES" or blank.
Thank you very much for your help.

 

[T. Valko]

Hi,

I would really appreciate if you could help me.
I am trying to count the unique values in a column based on possible duplicate entries in another column. I apologize for not being able to attach a file/picture of the data but it look like this.
A1 = "Customer"
A2:A9 has values: A,A,B,C,D,E,E,F
B1= "Exclusion flags"
B2:B9 has the value ("YES") only in B2 and B4. The rest of the B column is blank.
I am trying to count the number of flags in the B column based on possible duplicates in col A. I am having a really hard time as the duplicate values in col A may be either flagged "YES" or blank.
Thank you very much for your help.

Try this array formula**:

=SUM(IF(FREQUENCY(IF(B2:B9="Yes",MATCH(A2:A9,A2:A9,0)),ROW(A2:A9)-ROW(A2)+1),1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

 

[Tencijup]

Works like a charm. Thanks for the speedy reply!

 

[T. Valko]

Works like a charm. Thanks for the speedy reply!

You're welcome. Thanks for the feedback!