Count cell only only

[MR8]

Hi guys,

I did a search and wasn't able to find anything about a formula to count the record only once.

Is there a Count Formula to count the information once.

E.g

Col A
Coke
Coke
Rum
Brandy
Rum
Vodka
Vodka

So at the moment when I do a count formula it returns the value as 7, when I want it to return 5. As I want coke and Vodka to be counted only once.

Thanks

 

[Aladin Akyurek]

Thanks for your helps guys... can someone explain what the ctrl+shift+enter dose?

Look for "array formula" in Excel's Help.