So basically I have two columns. The first is a list of phone numbers, the second is a list of the dates these numbers were called.
Each phone number (and there are around 150) can have anywhere from a handful of dates called to up to 15000 (only one has over 10k).
So with that in mind, I need a way to get counts of the second column by date ranges. I want it for this past week, the week before that, the week before that, this past month, previous month, ytd etc.....
What's the best way to do this? I've tried messing around with a pivot table and either suck at using it or that's not the solution.
Please help.
Edit: if it matters, the phone number is always listed in the column to the left of the call date column.
Bookmarks