I want to make a pivot table like table. It pulls information, sorts dates in chronological order, and counts how many of those dates there are.
Since I work in Telecommunications, lets say that we have a callers who made 5 calls on 7/11, 2 on 7/12, and 6 on 5/30.
So my source data would have this kind of look:
Column A Column B
John Doe 7/11/08
Jane Cook 5/30/08
Billy Joe 7/12/08
And so forth. There isn't a pattern in the list of Callers or dates. There could be a series of Johns, then a Jane, back to Johns again. And the same with dates. It could be 7/11 for a bit, then 5/30 once, then back to 7/11. (Our CRM is really dumb, and information isn't always the most organized.)
SO the table I want to make looks like this:
Column A Column B
5/30/08 6
7/11/08 5
7/12/08 2
A pivot table can do what I just explained, but here's the catch. I need it to be auto refreshable. I change the source data, and the table auto updates. Is this possible.
Also, let's go a bit further....
How can I make a table that gives a summary of how many calls were made within the week, 2 weeks ago, 3 weeks ago , and how many calls made over 4 weeks ago. I'm sure it's just a =SUM() formula, but I think that it won't work because the "pivot table" will change that will return the SUM into a #REF!.
Thanks
Since I work in Telecommunications, lets say that we have a callers who made 5 calls on 7/11, 2 on 7/12, and 6 on 5/30.
So my source data would have this kind of look:
Column A Column B
John Doe 7/11/08
Jane Cook 5/30/08
Billy Joe 7/12/08
And so forth. There isn't a pattern in the list of Callers or dates. There could be a series of Johns, then a Jane, back to Johns again. And the same with dates. It could be 7/11 for a bit, then 5/30 once, then back to 7/11. (Our CRM is really dumb, and information isn't always the most organized.)
SO the table I want to make looks like this:
Column A Column B
5/30/08 6
7/11/08 5
7/12/08 2
A pivot table can do what I just explained, but here's the catch. I need it to be auto refreshable. I change the source data, and the table auto updates. Is this possible.
Also, let's go a bit further....
How can I make a table that gives a summary of how many calls were made within the week, 2 weeks ago, 3 weeks ago , and how many calls made over 4 weeks ago. I'm sure it's just a =SUM() formula, but I think that it won't work because the "pivot table" will change that will return the SUM into a #REF!.
Thanks