FamousMortimer
asked on
Excel 2010 Formula - Count Unique with Multiple Criteria
Hi Experts,
I am trying to get a count of unique job #'s in col H for each day in col C for each machine # in col I. I would like to accomplish this using a formula.
If you look at sheet 2 you will see what i mean. The data in sheet 2 should be the count of unique job #'s on the day specified in col A where the machine number = the corresponding value in row 2.
Book2.xlsx
Let me know if you have any questions.
Thanks
-Jeremy
I am trying to get a count of unique job #'s in col H for each day in col C for each machine # in col I. I would like to accomplish this using a formula.
If you look at sheet 2 you will see what i mean. The data in sheet 2 should be the count of unique job #'s on the day specified in col A where the machine number = the corresponding value in row 2.
Book2.xlsx
Let me know if you have any questions.
Thanks
-Jeremy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well, mine did use a formula, after a fashion :)
Glad to help!
Glad to help!
ASKER