Hello,

I have the followingformula that I am using as a named range in order to get it to be dynamic. I can then use the named range for a pivot or graph so that it always picks up the appropriate range as the data changes. In this case I have a table of data from L19 through S23. L19 has the headings in it. The issue I am having is right now the headings in O19 through S19 are currently blank. That may change over time but right now they are blank. The range below is resulting in the following: 'Graph Data'!$L$19:$S$23. That is the range if all of the headings were there. There is only data in L19 through N23. Any suggestions on how to get the last part of the formula COLUMN('Graph Data'!S19) more dynamic? I need it to recognize that currently the data in O19 through S19 is blank and not pick it up in the range.

Formula:
=ADDRESS(ROW('Graph Data'!L19),COLUMN('Graph Data'!L19),,,"Graph Data")&":"&ADDRESS(COUNTA('Graph Data'!$L$19:$L$23)+18,COLUMN('Graph Data'!S19))

Current Result:
'Graph Data'!$L$19:$S$19
Wanted Result:
'Graph Data'!$L$19:$N$23 (with the functionality to have N change based on data getting populated over time.

Thanks!

Regards,

Anthony