COUNT values in one Column for Distinct Value in Another Column - EXCEL

Question

Hello All,

I have two columns in Excel Worksheet and want to count column 2 for distinct values in Column 1.

Table:

Desired OUTPUT / RESULT:

Column 1	Column 2
YES	2
NO	2

Please help.

Thank You

Harun24hr · Accepted Answer · 2021-01-28 06:41:16Z

2

Try below formula-

=SUMPRODUCT(($B$2:$B$8=E2)/COUNTIF($A$2:$A$8,$A$2:$A$8&""))

If you have Excel365 then use below formulas-

E2=UNIQUE(B2:B8)
F2=COUNTA(UNIQUE(FILTER($A$2:$A$8,$B$2:$B$8=E2)))

answered Jan 28, 2021 at 6:34

Harun24hr

38.1k6 gold badges24 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1