Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 11:48 PM.


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