How to count the unrepeated objects on a excel list

's Computer Specifications

Frequently I have to use a pivot table to count first column unrepeated
elements. Is there a function to do this?

's Computer Specifications

See:

http://www.cpearson.com/excel/Duplicates.aspx

scroll down to:

Counting Distinct Entries In A Range
--
Gary''s Student - gsnu200743

"raul acosta" wrote:

> Frequently I have to use a pivot table to count first column unrepeated
> elements. Is there a function to do this?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count or Detect Graphic Objects in an Excel Spreadsheet Opened in Access?	plh	Microsoft Access Form Coding	0	26th Apr 2011 04:17 PM
newbie q - create list of objects from excel worksheet	eddiec	Microsoft C# .NET	1	24th Jul 2009 08:53 AM
Count New to the List, Count Leaving the List, Count Total	SteveC	Microsoft Excel Misc	1	2nd Feb 2009 09:48 PM
mark unrepeated cells	Dickery	Microsoft Excel New Users	1	13th May 2007 11:36 AM
Excel 2000, count, sort a list & count totals?	=?Utf-8?B?c3Vuc2xpZ2h0?=	Microsoft Excel Worksheet Functions	1	9th Apr 2007 05:46 PM