Count unique entries in Column A when contents in Column B is equal to a value

Hi,

Can someone help to find the Excel function/formula to count unique entries in Column A when a value is matched in Column B?

Need a function to return to count unique values in A when contents of column B is equal to BB.

Function should give 3 as the answer to below. Please help. Thanks.

Col A Col B
XX11 BB
XX22 AA
XX22 BB
XX33 BB
XX11 BB
XX22 AA
XX33 BB


Mathewfer

Hi,

Paste this array formula in and press Control +Shift +Enter at the same time::

Please Login or Register  to view this content.

If entered correctly, the formula will appear with {} around it automatically.

=SUM(SIGN(FREQUENCY(IF(B1:B7="BB",MATCH(A1:A7,A1:A7,)),MATCH(A1:A7,A1:A7,))))

Press Ctrl+Shift+Enter, not just Enter

Hi,

Thanks. It worked.

mathewfer

You're Welcome!