Counting for two criteria - brain drain
Any help would be greatly appreciated.
I need to count the number of dates in column C for each rep (column A)
for each Equipment type (column C).
A B C
Rep Eqp Date
1 a 31-Jan
2 b 31-Jan
1 a 1-Feb
2 a
result should be Rep one has 2 Rep two has -0- for equipment type a.
Thanks,
Steve
|