Need a formula to show first month of tracked savings

[MPBJR]

I have the sheet below to track savings projects, but I need to show what was the first month we tracked savings.
In the example below, I need a formula in cell O3 to look at the range R3:AC3 to find the first month with tracked savings and return the month/year value from the matching column in row 1.
So, in the example below, I would need the value if "03/24" from cell T1 to populate in O3 since March was the first month that project showed a savings.

I was thinking an index match formula might work but can't get the formula figured out.

Thank you.


View attachment 116717

 

[Phuoc]

Try this:

=MINIFS($R$1:$V$1,R3:V3,">0")

 

[MPBJR]

Thanks, but I just figured out my Index match formula, I have the below formula working.

=INDEX($R$1:$AC$1,MATCH(INDEX(R3:AC3,MATCH(TRUE,INDEX(R3:AC3>0,0),)),R3:AC3,0))

 

[Phuoc]

Thanks, but I just figured out my Index match formula, I have the below formula working.

=INDEX($R$1:$AC$1,MATCH(INDEX(R3:AC3,MATCH(TRUE,INDEX(R3:AC3>0,0),)),R3:AC3,0))

Just like this:

=INDEX($R$1:$AC$1,MATCH(TRUE,R3:AC3>0,0))