Counting unique values and Duplicates only once in Column A.

Hi Experts!

I am tyring to count values in column 'A'. I have a lot of duplicates as well as unique values.. However I would only like to count the Duplicates once.

For example the correct formula would output this:

Microsoft Excel - Supply Profile S&R JULY 2015 (version 1) [Recovered]_2015-08-17_14-03-34.jpg

Any help is appreciated. Thanks guys!

Originally Posted by GC Excel

Hi,
Here's a suggestion in B2, copy down:

Please Login or Register  to view this content.

Hi GC Excel,
Thanks for the quick reply! The formula does everything I requested.

Thanks