jellydonut
New Member
- Joined
- Jun 22, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi all
I'm trying to figure out how to return the column header (i.e. the month) for the first cell in each row. The issue I'm having is that my data contains empty strings, along zeroes and other numbers.
Currently for column F, the formula I'm using is:
INDEX(A$1:E$1,MATCH(TRUE,INDEX(A2:E2>0,),0))
The formula is working correctly for rows 3 and 4, but for row 2 has a formula that is returning an empty string, i.e. "", for cell A2
Because of the empty string, excel is returning "Jan" for cell F2, but I want it to return "Mar" since that is the first month where the value is truly above zero.
How can I fix this?
I'm trying to figure out how to return the column header (i.e. the month) for the first cell in each row. The issue I'm having is that my data contains empty strings, along zeroes and other numbers.
Currently for column F, the formula I'm using is:
INDEX(A$1:E$1,MATCH(TRUE,INDEX(A2:E2>0,),0))
The formula is working correctly for rows 3 and 4, but for row 2 has a formula that is returning an empty string, i.e. "", for cell A2
Because of the empty string, excel is returning "Jan" for cell F2, but I want it to return "Mar" since that is the first month where the value is truly above zero.
How can I fix this?