View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amber Amber is offline
external usenet poster
 
Posts: 68
Default Count items by day

I have a list of data where I want to know, by day, how many time different
items occur.

I have tried several possibilities with no luck. I would like to use a
pivot table but my data is not processing correctly.

1/1/2007 Internet
1/2/2007 Call Center
1/2/2007 Internet
1/2/2007 Call Center
1/3/2007 Call Center
1/3/2007 Internet

I would like the pivot table to be split between internet and call center
for each day, so I can plot these on a graph.