Forum Discussion
Solved
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...
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.
It has worked! Thank you!
Guys!
You can also use "(phrase)" in front of the (=) mark to avoid using an extra cell!
You can also use "(phrase)" in front of the (=) mark to avoid using an extra cell!
Yes, that is possible too. On the other hand, the extra cell makes it explicit what you're counting.