Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
199
Views
Topic starter
I have successfully used this formula to find the first value >0 in a row (ie, the first month in which the value is greater than 0)
INDEX(B$1:J$1,MATCH(TRUE,INDEX(B4:J4<>0,),0))
and now need to find the value >0 (for the LAST MONTH) so that I have 'start and end dates' listed in 2 columns to the right of the table.
Can anyone please help - see attached
[Image Can Not Be Found]
Posted : 04/07/2024 1:43 am
Good day Kelly,
How about a sample file? The image you attached is unavailable.
Don't forget to mentio the Excel version you're using
Posted : 06/07/2024 2:01 am
You could use:
=LOOKUP(2,1/(B4:J4<>0),B$1:J$1)
Posted : 06/07/2024 6:34 am
Topic starter
Thank you so much Velouria! This worked 🙂
=LOOKUP(2,1/(B4:J4<>0),B$1:J$1)
Posted : 12/07/2024 9:13 pm
