fb1990
asked on
Finding Usage Overlap
Hello EE,
I have a set of usage data that I need to group by unique usage. For example in my data, I need to know how many customer are contacting the help desk by using phone and mail format. In my data I can have customer who are using both mail and phone, phone only or mail only. In the attached example, I need to group my data like below
Mail_Only Phone_Only Phone_Mail
21 2 3
The data is in the data tab
Thanks in advance for your help
testdata.xlsx
I have a set of usage data that I need to group by unique usage. For example in my data, I need to know how many customer are contacting the help desk by using phone and mail format. In my data I can have customer who are using both mail and phone, phone only or mail only. In the attached example, I need to group my data like below
Mail_Only Phone_Only Phone_Mail
21 2 3
The data is in the data tab
Thanks in advance for your help
testdata.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER