Forum Discussion
Using OFFSET formula to create dynamic print area when cells contain formulas?
Good afternoon, Looking for help. I'm trying to set up a dynamic print area using OFFSET but, for the sheet I'm trying to print, all cells contain formulas so I've used IF and IFERROR to make th...
Assuming the column B has a formula which returns the text values in your actual file, then you may use the following formula for the named range...
=OFFSET(Charges!$A$1,0,0,COUNTIF(Charges!$B:$B,"?*"),12)