View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Azano
 
Posts: n/a
Default How do I use a pivot table to get an average count?

I have a list of transactions with colum headers of Month, Date, Weekday,
Time and the transaction data. I would like to see the average number of
transaction per hour per day. Can this be done in a pivot table?