Thread: count unique
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MAANI MAANI is offline
external usenet poster
 
Posts: 23
Default 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