Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-09-2011, 07:07 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Count in Excel Windows 7 32bit Count in Excel Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Please can you clarify what you mean by "unique"?


Do you want a count of the names which only appear once:

John
John
Peter
Bob

would give a count of 2, because John appears more than once so the unique names are Peter and Bob.



....or do you want a count of distinct names?

John
John
Peter
Bob

Would give a count of 3, because there are 3 distinct names in the list: John, Peter, Bob.
Reply With Quote
 

Thread Tools
Display Modes


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 12: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