Question
95 views

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  
6520       X
6520       X
6520       X
6520       X

1 person had this question

Abuse history


The answered status icon Answer
ediardp replied on

Hi,

This formula has to be entered as an array

=SUM(IF(FREQUENCY(IF(B1:B9="x",IF(A1:A9<>"",MATCH("~"&A1:A9,A1:A9&"",0))),ROW(A1:A9)-ROW(A1)+1),1))

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


progress