Forum Discussion
max values for changing cell references / segments in long list
Torsten,
try a pivot table.
"Date" and "Time" in the rows area. Filter "Time" >=16:30 and <=17:00.
"Stock price" in the values area and change the function to "Average".
Thank you, Detlef. Good and interesting workaround for some cases. Yet, doesn't really do the trick as the triggering times are changing, so I'd need to set the filter per day - almost same as changing the formula, or - likely better - blowing up the database such that each day starts and ends in predefined cells and then building workarounds.
Thanks again, T
"Yet, doesn't really do the trick as the triggering times are changing, so I'd need to set the filter per day"
Be more specific.
On what basis are the triggering times changing and why do you have to filter per day?
And it would be nice if you could provide a sample workbook.
Hi Detlef,
see attached. let's assume the triggering event is a 0.04 Euro drop within 30 min (I know how to model that, just makes the workbook a bit bigger, so inconvenient to share). If so, I could mark it with '1' or similar in column H. Then, I'd like the max value of the rest of the day.
Hope that helps clarify.
Thank you,T
