how to know the number of same cells ?

rosalind2 · #1 05-16-2014, 01:04 AM

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

rosalind2 · #2 05-16-2014, 02:18 AM

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

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

Pecoflyer · #3 05-16-2014, 06:16 AM

I'd go for the Pivot Table anytime

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Divide Number between cells	s7y	Excel Programming	2	01-15-2014 12:59 PM
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only	mag	Excel	0	10-28-2012 08:04 PM
How-TO format cells (FILL) by comparing cells	zanat0s	Excel	1	07-03-2012 04:27 AM
How to organize and insert blank cells between a huge number of data?	tareq	Excel	12	09-29-2010 02:12 PM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM