Posted to microsoft.public.excel.worksheet.functions

Irelandabroad Irelandabroad is offline

external usenet poster

Posts: 1

How can I count unique values

I have a worksheet with several columns:

Column F Column K
21/10/2008 Smith
27/10/2008 Jones
28/10/2008 Smith
25/11/2008 Jones
3/12/2008 Johns
10/02/2009 Johns
2/06/2009 Ryan
4/02/2009 Ryan

I need to prepare a formula which will count the number of times each unique
name appears in a month. (i have several years of data)

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Count Unique Values but not Filtered or Hidden Values	Lee	Excel Worksheet Functions	3	June 2nd 09 11:18 PM
Count Unique Values	Shane Goodman	Excel Worksheet Functions	4	December 14th 08 06:16 AM
Count Unique Values	Dave	Excel Worksheet Functions	5	December 4th 08 10:20 PM
count unique values, if ...	Averitt Engineer[_2_]	Excel Worksheet Functions	2	February 15th 07 06:41 PM
Count unique values and create list based on these values	vipa2000	Excel Worksheet Functions	7	August 5th 05 01:17 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us