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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One extra x axis item that wont go away - can anyone help? 3
More on "Data Range" - Dynamic Range Names 3
Multiple Dynamic Named Ranges across Columns 3
Dynamic Charting Question 4
Dynamic graph issue 2
Dynamic chart ranges (slight variation) 2
Graph to only include rows with data in 3
Dynamic Stacked Column Chart Help 2

Back
Top