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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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