Posted to microsoft.public.excel.misc

Chuck

external usenet poster

Posts: 90

Counting unique values with criteria

I need to count the number of unique cases given certain criteria. For
example,

Case # Code
3356 Stroke
3356 Stroke
3357 Cancer
3357 Cancer
3356 Cancer
The results should indicate: 1 unique case for Stroke; 2 unique cases for
Cancer. Thanks for any help.

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
Counting unique entries with criteria	Rachel	Excel Discussion (Misc queries)	10	January 15th 10 04:35 PM
Counting unique values with criteria	Kevin McCartney	Excel Worksheet Functions	10	December 31st 09 04:02 PM
Unique Counting With Multiple Criteria	Morton Detwyler[_2_]	Excel Worksheet Functions	9	March 16th 09 08:12 AM
Counting Unique Values with Multiple Criteria	Amber	Excel Worksheet Functions	3	September 25th 07 02:52 PM
Counting Unique Values Given Criteria	carl	Excel Worksheet Functions	2	August 20th 05 04:22 PM

All times are GMT +1. The time now is 06:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us