ExcelBanter - Lookup function with condition in time series data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Lookup function with condition in time series data (https://www.excelbanter.com/excel-worksheet-functions/95277-lookup-function-condition-time-series-data.html)

Tomas

Lookup function with condition in time series data

I have time series price data. For each date and price, I want to return the
very next date in which the price has dropped more than 10 cents.

How can I do this?

All times are GMT +1. The time now is 02:05 PM.