Hi,
The attached file shows a load of data, with figures on the right side from Jan-2023 to Dec-2028.
Columns I and J are "Start Date" and "Exit Date".
I want to flag any rows that have data that IS NOT zero outside of the date range.
For example,
If a building has a Start Date of 1st Dec 2023 and Exit Date of 1st May 2025, then I would want to flag this row if there are numbers other than zero either before Dec 2023 or after May 2025.
Hope that makes sense!
