I'm doing an analysis of calls received over the last 3 months to a covid helpline run by volunteers. Unfortunately my excel skills have rusted and I've forgotten how to do something.
The raw data is held in a a worksheet, each line represents a call and Column B has the name of each caller.
I want to create a table in another worksheet where the rows are the number of calls a person made to the helpline and the columns represent the number of people who made that number of calls. (eg In lay language the table would be able to tell me how many people had made, say, 3 calls.)
Can someone please help me out.
Please bear with me as I fear there are other things Ive forgotten - so there may be other posts
The raw data is held in a a worksheet, each line represents a call and Column B has the name of each caller.
I want to create a table in another worksheet where the rows are the number of calls a person made to the helpline and the columns represent the number of people who made that number of calls. (eg In lay language the table would be able to tell me how many people had made, say, 3 calls.)
Can someone please help me out.
Please bear with me as I fear there are other things Ive forgotten - so there may be other posts