That is no longer necessary !!
Because we can calculate the number of unique values in a list with a simple formula.
And what formula is that ?? Let's see ...
Everything you need to know about Excel. Examples of functions and formulae, charts, tips, tricks, pivot tables, macros, power pivot