Hello,

I am working on a project and I am looking to identify consecutive months of sales. I have been able to pull in the data need by using the following formula for months of consecutive sales: {=MAX(FREQUENCY(IF(U126:AF126>0,COLUMN(U126:AF126)),IF(U126:AF126=0,COLUMN(U126:AF126))))}

What I would like to do next is in the cell to the right of this formula I would like to pull in the header information from the first consecutive cell. I have an example below from my data set. The far right column I have manually populated the data but would like to run a formula to pull the data in. My data set is fairly large. - Thank you very much.

[TABLE="border: 0, cellpadding: 0, cellspacing: 0"]

[TD="width: 117"] [/TD]

[TD="width: 64"]2017[/TD]

[TD="width: 64"]2017[/TD]

[TD="width: 64"]2017[/TD]

[TD="width: 64"]2017[/TD]

[TD="width: 64"]2017[/TD]

[TD="width: 64"]2018[/TD]

[TD="width: 64"]2018[/TD]

[TD="width: 64"]2018[/TD]

[TD="width: 64"]2018[/TD]

[TD="width: 64"]2018[/TD]

[TD="width: 64"]2018[/TD]

[TD="width: 64"]2018[/TD]

[TD="width: 127"] [/TD]

[TD="width: 64"] [/TD]

August

[/td]September

[/td]October

[/td]November

[/td]December

[/td]January

[/td]February

[/td]March

[/td]April

[/td]May

[/td]June

[/td]July

[/td]Material

[/td]20

[/td]21

[/td]22

[/td]23

[/td]24

[/td]25

[/td]26

[/td]27

[/td]28

[/td]29

[/td]30

[/td]31

[/td]

[TD="width: 127"]Frequency of consecutive Sales[/TD]

Need to Pop this Cell

[/td]97077.01.050.6

[/td]

[TD="align: right"]10824[/TD]

[TD="align: right"]1320[/TD]

[TD="align: right"]792[/TD]

[TD="align: right"]2376[/TD]

[TD="align: right"]1857[/TD]

[TD="align: right"]528[/TD]

[TD="align: right"]5[/TD]

March

[/td]97602.08.108.0

[/td]

[TD="align: right"]108[/TD]

[TD="align: right"]162[/TD]

[TD="align: right"]216[/TD]

[TD="align: right"]108[/TD]

[TD="align: right"]162[/TD]

[TD="align: right"]594[/TD]

[TD="align: right"]108[/TD]

[TD="align: right"]1080[/TD]

[TD="align: right"]324[/TD]

[TD="align: right"]378[/TD]

[TD="align: right"]5[/TD]

March

[/td]97120.08.192.0

[/td]

[TD="align: right"]78[/TD]

[TD="align: right"]156[/TD]

[TD="align: right"]78[/TD]

[TD="align: right"]234[/TD]

[TD="align: right"]156[/TD]

[TD="align: right"]78[/TD]

[TD="align: right"]156[/TD]

[TD="align: right"]5[/TD]

March

[/td]97202.01.102.0

[/td]

[TD="align: right"]270[/TD]

[TD="align: right"]108[/TD]

[TD="align: right"]216[/TD]

[TD="align: right"]216[/TD]

[TD="align: right"]108[/TD]

[TD="align: right"]5[/TD]

March

[/td]97202.01.078.0

[/td]

[TD="align: right"]216[/TD]

[TD="align: right"]162[/TD]

[TD="align: right"]162[/TD]

[TD="align: right"]486[/TD]

[TD="align: right"]108[/TD]

[TD="align: right"]5[/TD]

March

[/td]97123.01.071.5

[/td]

[TD="align: right"]696[/TD]

[TD="align: right"]1044[/TD]

[TD="align: right"]348[/TD]

[TD="align: right"]1044[/TD]

[TD="align: right"]1218[/TD]

[TD="align: right"]3480[/TD]

[TD="align: right"]1914[/TD]

[TD="align: right"]5[/TD]

October

[/td]

[/TABLE]