count unique
Teethless,I'm applying your function in a workbook,my source is in different
workbook,and my source has 65536 rows,when I applied your function it returns
#N/A also I can't save the file !!!
"Teethless mama" wrote:
Try this:
Data in A1:C8
Criteria
D1: holds date
E1: holds product #
=SUM(N(FREQUENCY(IF((A1:A8=D1)*(C1:C8=E1),MATCH(B1 :B8,B1:B8,)),MATCH(B1:B8,B1:B8,))0))
ctrl+shift+enter, not just enter
"MAANI" wrote:
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
|