Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-16-2014, 01:04 AM
rosalind2 rosalind2 is offline how to know the number of same cells ? Windows XP how to know the number of same cells ? Office 2007
Novice
how to know the number of same cells ?
 
Join Date: May 2014
Posts: 2
rosalind2 is on a distinguished road
Default how to know the number of same cells ?

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 Type: xlsx file.xlsx (13.6 KB, 9 views)
Reply With Quote
  #2  
Old 05-16-2014, 02:18 AM
rosalind2 rosalind2 is offline how to know the number of same cells ? Windows XP how to know the number of same cells ? Office 2007
Novice
how to know the number of same cells ?
 
Join Date: May 2014
Posts: 2
rosalind2 is on a distinguished road
Default

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

http://www.wikihow.com/Find-Duplicates-in-Excel
Reply With Quote
  #3  
Old 05-16-2014, 06:16 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline how to know the number of same cells ? Windows 7 64bit how to know the number of same cells ? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

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
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to know the number of same cells ? 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 know the number of same cells ? How-TO format cells (FILL) by comparing cells zanat0s Excel 1 07-03-2012 04:27 AM
how to know the number of same cells ? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft