software

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

=OFFSET(Consolidated!$A$121,0,1,1,COUNTA(Consolida ted!$B$121:$IV$121)).The problem is that some of the cells contains, blanks and I can't seem
to make it include all of the information.

What can I do to make this pull pulls in all columns even if there are
blanks?Thanks in advance.

Michellle--
bountifulgrace
------------------------------------------------------------------------
bountifulgrace's Profile: www.excelforum.com/member.php...oamp;userid=33237
View this thread: www.excelforum.com/showthread...hreadid=530587try 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(quot;zzzzzzzquot;,$121:$121))

--
Don Guillett
SalesAid Software

quot;bountifulgracequot;
lt;bountifulgrace.25uqxz_1144342806.0592@excelforu m-nospam.comgt; wrote in
message news:bountifulgrace.25uqxz_1144342806.0592@excelfo rum-nospam.com...
gt;
gt; I have the follwing formula to automatically update a graph (the date is
gt; across columns)
gt;
gt; =OFFSET(Consolidated!$A$121,0,1,1,COUNTA(Consolida ted!$B$121:$IV$121)).
gt;
gt;
gt; The problem is that some of the cells contains, blanks and I can't seem
gt; to make it include all of the information.
gt;
gt; What can I do to make this pull pulls in all columns even if there are
gt; blanks?
gt;
gt;
gt; Thanks in advance.
gt;
gt; Michellle
gt;
gt;
gt; --
gt; bountifulgrace
gt; ------------------------------------------------------------------------
gt; bountifulgrace's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33237
gt; View this thread: www.excelforum.com/showthread...hreadid=530587
gt;