R
Rick
I've read other questions and answers on this subject but haven't found
anything that works for my situation. I need to count unique records based on
mulitple criteria, for example:
Jones CompA Employee Project1
Jones CompA Employee Project2
Jones CompA Employee Project3
Smith CompA Contractor Project4
Smith CompA Contractor Project2
Ying CompB Employee Project6
Ying CompB Employee Project7
Ying CompB Employee Project8
Ying CompB Employee Project9
Baum CompA Employee Project2
Baum CompA Employee Project10
Elvis CompA Contractor Project4
How do I find the number of...
a) CompA Employees? Should be 2.
b) CompA Contractors? Should be 2.
c) CompB Employees? Should be 1.
d) Employees? Should be 3.
e) Contractors? Should be 2.
Thanks in advance.
anything that works for my situation. I need to count unique records based on
mulitple criteria, for example:
Jones CompA Employee Project1
Jones CompA Employee Project2
Jones CompA Employee Project3
Smith CompA Contractor Project4
Smith CompA Contractor Project2
Ying CompB Employee Project6
Ying CompB Employee Project7
Ying CompB Employee Project8
Ying CompB Employee Project9
Baum CompA Employee Project2
Baum CompA Employee Project10
Elvis CompA Contractor Project4
How do I find the number of...
a) CompA Employees? Should be 2.
b) CompA Contractors? Should be 2.
c) CompB Employees? Should be 1.
d) Employees? Should be 3.
e) Contractors? Should be 2.
Thanks in advance.