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. Doable but not efficient at all as it is the old school method. 😁

With the introduction of UNIQUE function, doing a distinct count with formula becomes easy. Look at this:

 = COUNTA( UNIQUE (range) )

Easy! Isn’t it? 😎