Hi All,
I am trying to calculate values in one column based on a time period within a separate column.
The 'time' column and corresponding 'Lq' values are not always in the same columns on each sheet. I started my marco with the find function but am lost after that.
In the following data set I would like to calculate the average Lq value between the time period 14:40 - 15:00
Time Lq
14:35 68.6
14:40 67.8
14:45 70.2
14:50 68.3
14:55 68.5
15:00 69.9
Average 14:40 - 15:00 68.7
Please Login or Register to view this content.
Bookmarks