View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ser1609 ser1609 is offline
external usenet poster
 
Posts: 2
Default Creating daily average from multiple values per day

I've got a dataset with measurements at different time intervals per day.
Most are on the hour, so I could just create daily average for each 24
entries, but many have more (or less) per day. How do I create a daily
average of each group of numbers per day? The data is formatted as column
A=date, column B=amount