R
Rick
I've read many questions and answers similar to my problem but I can't find
one that works. I need to count the number of unique records based on 2 or
more criteria (roughly 1000 rows), for example:
Jones CompA Employee Project12
Jones CompA Employee Project44
Smith CompB Employee Project21
Smith CompB Employee Project09
Smith CompB Employee Project51
Smith CompB Employee Project04
Ying CompA Contractor Project6
Ying CompA Contractor Project12
Jones CompB Employee Project76
Jones CompB Employee Project04
Jones CompB Employee Project82
King CompA Contractor Project29
How do I count the number of:
a) CompA Employees? Should be 1.
b) CompA Contractors? Should be 2.
c) Employees? Should be 4.
d) CompA? Should be 3.
Thanks in advance.
one that works. I need to count the number of unique records based on 2 or
more criteria (roughly 1000 rows), for example:
Jones CompA Employee Project12
Jones CompA Employee Project44
Smith CompB Employee Project21
Smith CompB Employee Project09
Smith CompB Employee Project51
Smith CompB Employee Project04
Ying CompA Contractor Project6
Ying CompA Contractor Project12
Jones CompB Employee Project76
Jones CompB Employee Project04
Jones CompB Employee Project82
King CompA Contractor Project29
How do I count the number of:
a) CompA Employees? Should be 1.
b) CompA Contractors? Should be 2.
c) Employees? Should be 4.
d) CompA? Should be 3.
Thanks in advance.