Tag Archives: COUNTA

Distinct count using functions in #Excel 365 is so easy

Have your ever wanted to count how many distinct items in a range? Though a common task, there was not build-in functional for it. Perhaps we can make a distinct list using advanced filter first then we count the outcome. … Continue reading

Rate this:

Posted in Excel 365, Excel Tips, Formula | Tagged , , | Leave a comment