unable to use pivot table for this--counting numbers

mabelline

New Member
Joined
Dec 19, 2003
Messages
12
I have a massive excel data dump of phone numbers by business. There are three columns in my spreadsheet. Appox 20,000 records. The first is phone number (formatted as a number) and the second column is the business. The third column is day of the month. I need to have a chart that tells me which businesses received more than one call during the time period. I want to break it down to month and then maybe to day if I need to...The problem is that I need to have the columns mutually exclusive...so if someone called in 3 times, they did not also call in four times.

# who called in once # twice # 3x
Client 1 300 200 400
Client 2
Client 3
Client 4
Client 5
Client 6
Client 7
Client 8
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Does the day of the month column also include the month? or is the data all in one month?

You can create a calculated field in the pivot table > calculated field to some of what you wish.

Assuming that each of the 20,000 rows is 1 phone call, and the Client is the business, you can drag the phone number column in to the "body" of the pivot table, and select count as aggregate ( the business would be on left side as the row)

If you drag the day as the column header you can then see the count by day
 
Upvote 0
The data is all in one month.

I don't care about retaining the identity of the phone number. I simply want to know, by business, how many people called in once, twice, three or four or more times.

If I do a count, it counts all the numbers and that doesn't help me....
 
Upvote 0

Forum statistics

Threads
1,223,578
Messages
6,173,167
Members
452,504
Latest member
frankkeith2233

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top