Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-09-2011, 12:48 AM
zanat0s zanat0s is offline Count in Excel Windows 7 64bit Count in Excel Office 2007
Novice
Count in Excel
 
Join Date: May 2011
Posts: 8
zanat0s is on a distinguished road
Default Count in Excel

Hi,



I have a question. Lets say i have an excel with some data. I need to count in a column(or a row) all the unique entries.

for example
Name
1 John
2 george
3 Merlin
4 Darko
5 George
6
7 Pikachu
8 Superman
9 Drado

I want to count how many Unique names appear on the excel, not the total number of names. What is the exact formula?

Thank you
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Count in Excel Count with multiple conditions bundy5150 Excel 4 02-22-2011 10:00 AM
Don't count hidden slides Lu_Argentina PowerPoint 0 10-12-2010 02:12 PM
How to Count from Different Cells? Shahzad Excel 3 06-26-2010 01:06 AM
changing word count hamster Word 3 06-03-2010 01:53 AM
Don't count 0 in a chart Rmaisone Excel 0 08-21-2006 12:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:31 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