Dynamic Named Range

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
 
D

Don Guillett

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))
 

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
Plotting Graph with dynamic table 3
Copy addition formula of non-consecutive horizontal cells 2
Dynamic graph issue 2
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Multiple Dynamic Named Ranges across Columns 3
More on "Data Range" - Dynamic Range Names 3
Data Range Question 1

Top