#### whitealbum

##### New Member

- Joined
- Apr 2, 2019

- Messages
- 5

I have a 2 row data set with over 100 cells. The first row contains time values, the second row a numeric value.

I have to find 2 given time values in the first row, and the I need to get the mean between the numeric values under the found values. But here is the tricky part: the mean should not only be based on those 2 found numeric values, but also it should include all numeric values between those 2 values.

i work with live data, so all values can change every day.

I used Hlookup to return the 2 numeric values, but I have no idea how to include all those other numeric values between them...to get the mean.

I hope this challenge can be solved by anyone.

Kind regards