I hope you do enjoy this free blog. I only ask one thing from you in return, click in one of the ads
Showing posts with label SUMPRODUCT function. Show all posts
Showing posts with label SUMPRODUCT function. Show all posts

Monday, 16 March 2015

How to count the number of unique values in a range in Excel

Hello, on many occasions we have a list or range with lots of data, and we wondered how many of those values or data are unique, and we have had to develop a complex solution by adding helper columns and doing multiple operations.


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 ...