| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Print Range with cells containing formulas ! | Excel Discussion (Misc queries) | |||
| Dynamic Range in Excel that won't count formulas | Excel Discussion (Misc queries) | |||
| Ignore Data for Dynamic Range | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Dynamic bar chart, must ignore "n/a" data... | Charts and Charting in Excel | |||
Linear Mode
