Identify the month from specific accumulation number without helper row/column

[Hendric]

Hi All,

Can you help what formula to identify the month with specific accumulation number as per table below please?
I need to identify which month has given result 300 (accumulation A2:L2/A3:L3) for column M2/M3 without helper row.

	A	B	C	D	E	F	G	H	H	J	K	L	M
1	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2	0	0	100	100	100	100	100	0	0	0	0	0	May
3	0	0	0	0	50	50	100	100	100	100	0	0	Aug

<tbody>
</tbody>

Really much appreciated for your help.

Thanks,

 

[Momentman]

it doesn't appear difficult but i guess you might have to explain better.

Maybe use an example, of an accumulation and what month results from it, that should help

 

[Marcelo Branco]

Maybe...

M2 copied down
=INDEX(A$1:L$1,MATCH(1,INDEX(--(SUBTOTAL(9,OFFSET(A2,,,,COLUMN(A2:L2)-COLUMN(A2)+1))>=300),),0))

M.

 

[Hendric]

Hi Marcelo,

It is what I am looking for and work. Thank you very much.

Regards,

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.