I've attached an example book for reference.
I'm struggling to write a formula that can pull information related to the last time GP was reduced. In the attached workbook, you will see column J represents a month/over month comparison to GP on a job. I'm trying to pull the amount that is last shown as less than $0, and then I can write an index/match formula that can pull the year/month. Any suggestions on which formula to use in order to pull the last time it was negative (Orange highlights are the rows that it should find).
Bookmarks