Dynamic Named Range

  • Thread starter Thread starter bountifulgrace
  • Start date Start date
B

bountifulgrace

I have the follwing formula to automatically update a graph (the date i
across columns)

=OFFSET(Consolidated!$A$121,0,1,1,COUNTA(Consolidated!$B$121:$IV$121)).


The problem is that some of the cells contains, blanks and I can't see
to make it include all of the information.

What can I do to make this pull pulls in all columns even if there ar
blanks?


Thanks in advance.

Michelll
 
try this idea if text. substitute 999999999 if numbers. Excel will put in
the sheet if you do if while on the consolidated sheet

=OFFSET($A$121,0,0,1,MATCH("zzzzzzz",$121:$121))
 
Back
Top