LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Me Me is offline
external usenet poster
 
Posts: 67
Default Multiple averages in large continous data field

I figured I'd try this once more. :-)

In column C I have the date, in column D I have the time, and in column E I
have a measurement taken at that date/time period. Theres 25,000+ rows of
this data, so doing what I need wouldnt be something easily done manually.

Based on the date and time, I would like to find the average of the
measurements taken per date, per shift. Day shift is 7:00 AM until 9:00 PM,
and
night shift is 9:01 PM until 6:59 AM. The night shift does not need to be
spread across dates, as for example, August 30, 9:00 PM until midnight is a
separate date than August 31, 12:01 AM until 6:59 AM.

I would like to post the results for each shift per date in column G at the
first two rows per date. There are about 200 rows per date, so where the
results would be about 200 rows apart.

Is there anyway this can be done?

Thanks in advance.
 
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
Multiple averages in large continous data field Me Excel Discussion (Misc queries) 2 August 30th 07 03:38 PM
Averages formula for multiple ranges Raytown Excel Worksheet Functions 2 April 23rd 07 02:39 PM
Pivot Table - Dragging multiple items into data field J@Y Excel Discussion (Misc queries) 1 January 12th 07 12:52 AM
how do i get field name from result of MAX or LARGE function nick Excel Worksheet Functions 4 August 13th 06 06:32 AM
Compile/Analyze Word Form Field data from multiple forms? jgundel Excel Discussion (Misc queries) 3 July 14th 05 02:54 AM


All times are GMT +1. The time now is 09:21 PM.

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

About Us

"It's about Microsoft Excel"