![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
i found an extremely easy way for this. in the following link, method 4. thanx everyone :
http://www.wikihow.com/Find-Duplicates-in-Excel |
#3
|
||||
|
||||
![]()
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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
![]() |
tareq | Excel | 12 | 09-29-2010 02:12 PM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |