Try this array formula... Can i take it a step further to bring back the month the first time A5:G5 is less than 0?
Confirm with Ctrl+Shift+Enter not just Enter![]()
=INDEX(A3:G3,1,MATCH("-*",TEXT(A4:G4,"0"),0))
See A7 in this workbook, we seem to be talking about different rows.
Bookmarks