LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMPRODUCT to count items with duplicates where another column contains two defined items PCLIVE Excel Worksheet Functions 4 September 8th 07 10:33 AM
Count Numbered Items JB Excel Discussion (Misc queries) 3 January 13th 07 02:39 PM
Count unique items in groups GarToms Excel Worksheet Functions 2 August 24th 06 04:24 AM
Count items on the list dannyboy213 Excel Discussion (Misc queries) 5 February 2nd 06 08:12 PM
How to count how many different items in one colum? Letizia Excel Worksheet Functions 1 April 7th 05 04:24 PM


All times are GMT +1. The time now is 04:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"