SOLVED

# Counting A Column Uniquely Based On Another Column

Copper Contributor

# Counting A Column Uniquely Based On Another Column

I have a column (A) which I use check (ü) or false (û) ─ Wingdings font ─ to indicate whether people from column (C) are joined in group or not.

There are duplicates in the column (C), which I write people's names in, hence there are duplicate checks (ü) or falses (û) in column (A).

I want to count checks (ü) or falses (û) without duplicate, based on column (C); since obviously every checks (ü) or falses (û) would be duplicated multiple times because they have no distinction like names!

I already have a formula for counting column (C) without duplicate which I share below:
=SUM(IF(FREQUENCY(IF(LEN(a2:a497)>0,MATCH(a2:a497,a2:a497,0),""),IF(LEN(a2:a497)>0,MATCH(a2:a497,a2:a497,0),""))>0,1))

4 Replies
best response confirmed by Morie10 (Copper Contributor)
Solution

# Re: Counting A Column Uniquely Based On Another Column

The attached workbook proposes two solutions: one using formulas, and the other using a pivot table whose source data have been added to the Data Model.

# Re: Counting A Column Uniquely Based On Another Column

It has worked! Thank you!

# Re: Counting A Column Uniquely Based On Another Column

Guys!
You can also use "(phrase)" in front of the (=) mark to avoid using an extra cell!

# Re: Counting A Column Uniquely Based On Another Column

Yes, that is possible too. On the other hand, the extra cell makes it explicit what you're counting.

1 best response

Accepted Solutions
best response confirmed by Morie10 (Copper Contributor)
Solution

# Re: Counting A Column Uniquely Based On Another Column

The attached workbook proposes two solutions: one using formulas, and the other using a pivot table whose source data have been added to the Data Model.