Forum Discussion
Morie10
Jun 08, 2024Copper 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 wri...
- Jun 08, 2024
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.
HansVogelaar
Jun 08, 2024MVP
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.
- Morie10Jun 09, 2024Copper ContributorIt has worked! Thank you!
- Morie10Jun 09, 2024Copper ContributorGuys!
You can also use "(phrase)" in front of the (=) mark to avoid using an extra cell!- HansVogelaarJun 09, 2024MVP
Yes, that is possible too. On the other hand, the extra cell makes it explicit what you're counting.