#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default Counting Unique

Is there a way to count only unique entries? I have a list of a lot
of reocuring data, but I'd like to count how many unique entries
overall and then also for a date range, which would be in an adjacent
column.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default Counting Unique

See:
http://www.cpearson.com/excel/Duplicates.aspx
--
Gary''s Student - gsnu2007h


"tonyalt3" wrote:

Is there a way to count only unique entries? I have a list of a lot
of reocuring data, but I'd like to count how many unique entries
overall and then also for a date range, which would be in an adjacent
column.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting unique items...please help Lisa Excel Worksheet Functions 9 March 1st 07 09:23 PM
Unique counting Michael Excel Discussion (Misc queries) 19 November 27th 06 09:28 AM
Counting Unique Codes pgiessler Excel Discussion (Misc queries) 1 August 16th 06 04:56 PM
Counting Unique Entries SouthCarolina Excel Discussion (Misc queries) 7 April 14th 06 01:18 PM
Counting Unique Values carl Excel Worksheet Functions 9 July 25th 05 12:44 PM


All times are GMT +1. The time now is 04:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"