Thread: ignore formulas in dynamic range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
skippy51 skippy51 is offline
external usenet poster
  
Posts: 4
Default 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?
Reply With QuoteReply With Quote