Count Distinct Values in Excel

This video will tell you tutorial how to Count Distinct Values in Excel and explain the logic.

[LuisPax]

Thank you and a question, is there possibility of rounding errors if larger data sets? And how it’s addressed on the formula? Does that make sense? Thanks

[jackjohnshei]

very good video ! and how to exclude blank cells or zero value from distinct count in pivot table