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
count unique	MAANI	Excel Worksheet Functions	4	October 22nd 08 06:02 AM
Count Unique Records	CTAY	New Users to Excel	3	July 24th 08 05:35 AM
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 if text	Mike Fogleman	Excel Worksheet Functions	16	January 21st 07 07:47 PM
Count Unique Entries	SouthCarolina	Excel Worksheet Functions	4	April 14th 06 11:44 PM

All times are GMT +1. The time now is 11:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us