ignore formulas in dynamic range
 

Ihave a graph that is dynamic. I use the following range
=OFFSET(sheet1!$A$1,COUNTA(sheet1!$A:$A)-1,0,-MIN(chtlen,COUNTA(sheet1!$A:$A)-1),1)
If I have a formula in that column $A:$A it counts that also. How do I
ignore the cells with formula's in them so that the range does not change
until the formula produces a number?

ignore formulas in dynamic range
 

Maybe something like

=OFFSET(Sheet1!$A$1,COUNTIF(Sheet1!$A2:$A10,"0"), 0,-MIN(chtlen,COUNTIF(Sheet1!$A2:$A10,"0")),1)

Depends on what numbers your formulas should produce...

HTH,
Bernie
MS Excel MVP


"skippy51" wrote in message
...
Ihave a graph that is dynamic. I use the following range
=OFFSET(sheet1!$A$1,COUNTA(sheet1!$A:$A)-1,0,-MIN(chtlen,COUNTA(sheet1!$A:$A)-1),1)
If I have a formula in that column $A:$A it counts that also. How do I
ignore the cells with formula's in them so that the range does not change
until the formula produces a number?