Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count unique
Use a pivot table....google for help on pivot table in excel "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count unique
Enter in D2 and copy down...
=Sumproduct(--(A$2:A$1000=A2),--(C$1:C$100=C2),--(B$2:B$100)) [You will get the count multiple times for the same combination] Change 100 to the end of you data set... "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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count unique
Teethless mama formula did it ,Thank you guys
"Sheeloo" wrote: Enter in D2 and copy down... =Sumproduct(--(A$2:A$1000=A2),--(C$1:C$100=C2),--(B$2:B$100)) [You will get the count multiple times for the same combination] Change 100 to the end of you data set... "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count unique | Excel Worksheet Functions | |||
Count Unique Records | New Users to Excel | |||
Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
Count unique if text | Excel Worksheet Functions | |||
Count Unique Entries | Excel Worksheet Functions |