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.

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[TD="align: center"]F
[/TD]
[TD="align: center"]G
[/TD]
[TD="align: center"]H
[/TD]
[TD="align: center"]H
[/TD]
[TD="align: center"]J
[/TD]
[TD="align: center"]K
[/TD]
[TD="align: center"]L
[/TD]
[TD="align: center"]M
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD="align: center"]Jan
[/TD]
[TD="align: center"]Feb
[/TD]
[TD="align: center"]Mar
[/TD]
[TD="align: center"]Apr
[/TD]
[TD="align: center"]May
[/TD]
[TD="align: center"]Jun
[/TD]
[TD="align: center"]Jul
[/TD]
[TD="align: center"]Aug
[/TD]
[TD="align: center"]Sep
[/TD]
[TD="align: center"]Oct
[/TD]
[TD="align: center"]Nov
[/TD]
[TD="align: center"]Dec
[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD="align: center"]0
[/TD]
[TD="align: center"]0
[/TD]
[TD="align: center"]100
[/TD]
[TD="align: center"]100
[/TD]
[TD="align: center"]100
[/TD]
[TD="align: center"]100
[/TD]
[TD="align: center"]100
[/TD]
[TD="align: center"]0
[/TD]
[TD="align: center"]0
[/TD]
[TD="align: center"]0
[/TD]
[TD="align: center"]0
[/TD]
[TD="align: center"]0
[/TD]
[TD="align: center"]May
[/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD="align: center"]0
[/TD]
[TD="align: center"]0
[/TD]
[TD="align: center"]0
[/TD]
[TD="align: center"]0
[/TD]
[TD="align: center"]50
[/TD]
[TD="align: center"]50
[/TD]
[TD="align: center"]100
[/TD]
[TD="align: center"]100
[/TD]
[TD="align: center"]100
[/TD]
[TD="align: center"]100
[/TD]
[TD="align: center"]0
[/TD]
[TD="align: center"]0
[/TD]
[TD="align: center"]Aug
[/TD]
[/TR]
</tbody>[/TABLE]

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.