hi. first of all i should say im very beginner in excel. I have a file that as you can see in attachment, it has one column. some of the cells have same contents, e.g. " department of pediatrics ". I'd like to know if it is possible to know that how many of same cells there are ? i mean, i wanna know how many times " department of pediatrics " is repeated ? i need to do this for each cell. if it can't be done by excel, is there any other software that can do this ?

thanks for your help

Attached Files

file.xlsx (13.6 KB, 9 views)

i found an extremely easy way for this. in the following link, method 4. thanx everyone :

http://www.wikihow.com/Find-Duplicates-in-Excel

I'd go for the Pivot Table anytime

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post