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!