dynamic range

[ehsas69]

When adding formula for x axis in chart it is recoginazing the cell

=OFFSET(Sheet1!$D$3,0,MATCH(BigNum,Sheet1!$D$3:$AK$3)-13,1,13)


I have defined the names as title.

in row 3 I have years like apr,may,jun from d3 to ak3.

pls help

Thanks

 

[ehsas69]

pls help

 

[Aladin Akyurek]

pls help

If D3:AK3 houses text (not numbers), you'll need:

=OFFSET(Sheet1!$D$3,0,MATCH(REPT("z",255),Sheet1!$D$3:$AK$3)-13,1,13)

 

[ehsas69]

Thanks a lot