Hi. I wrote a process in Excel to load data and show graphs that has been running for over a year. I realized when it didn't work yesterday that I didn't handle if there is a bad data value, which rarely happens but it could happen again.
The current formula in the cell, which is below, works if there are no data issues in the text file.
I am trying to figure out how to change the formula to look at the J column and return the cell only if that cell is followed by at least 5 cells with 0.00 in them.
I've included an image of how the data looks in column J. Normally the value in J2 is a non-zero value.
My old formula would return J1, based on this data, but the new formula or function should return J7 (because 5 cells follow that have 0.00).
Thanks for any help you can offer.