Count unique values (two columns of data)

PMBO asked on

I need to count the X's in column B only if the values in Column A are unique.

The example below would result in a count of 2 (one X for 5262, and one X for 6520)

I tried several formulas (sumproduct, countifs) but can't get the correct answer.

5262      X
6520       X
6520       X
6520       X
6520       X

1 person had this question

Abuse history

The answered status icon Answer
ediardp replied on


This formula has to be entered as an array


with the formula edited press CTRL+SHIFT+ENTER

If this post is helpful or answers the question, please mark it so, thank you.
Be the first person to mark this helpful

Abuse history