Posted to microsoft.public.excel.worksheet.functions

MAANI

external usenet poster

Posts: 23

count unique

This is what I have:
A (Date) B (Emp #) C (Product #)
10-Oct-08 2 700
10-Oct-08 3 710
11-Oct-08 3 700
12-Oct-08 1 702
12-Oct-08 1 700
12-Oct-08 2 700
12-Oct-08 2 700
12-Oct-08 2 740

I want a formula to count how many employees worked on a certain product in
a certain day . Example: on 12-Oct-08,2 employees worked on product #
700.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
Attempting to sort unique/only count first record in each unique g	MJW[_2_]	Excel Discussion (Misc queries)	3	August 10th 07 02:56 PM
Count Unique Values	Averitt Engineer[_2_]	Excel Worksheet Functions	17	February 17th 07 09:57 AM
Count unique entries...	ChuckF	Excel Worksheet Functions	5	October 12th 06 05:48 AM
Unique entry count	Montrose77	Excel Discussion (Misc queries)	7	August 15th 06 08:28 PM
Count Unique Entries	SouthCarolina	Excel Worksheet Functions	4	April 14th 06 11:44 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us