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