I have been struggling with this one and couldnt find answers on google! Though am sure the answer is fairly easy.
So i have a list of duplicate values in a column as below.
I need an excel formula (non vba) which results "3". Because we have only A, B and C regardless...