Hi,
I have the following formula =OFFSET(Input!$B$8,1,0,COUNTA(Input!$B:$B)-1,5), column B has a formula which returns a blank based on another cell. I am trying to offset the range so it does not include the blank formula rows.
Thanks
Hi,
I have the following formula =OFFSET(Input!$B$8,1,0,COUNTA(Input!$B:$B)-1,5), column B has a formula which returns a blank based on another cell. I am trying to offset the range so it does not include the blank formula rows.
Thanks
Re: OFFSET formula to ignore cell with a blank formula
You could do this:
COUNTA(Input!$B:$B)-COUNTBLANK(Input!$B:$B)
Re: OFFSET formula to ignore cell with a blank formula
Hi Ali,
This did not work, I am trying to create a dynamic named range, my first row of data is from B9:F9, I would like to select the range until there is a blank return on the formula in column B.
Re: OFFSET formula to ignore cell with a blank formula
OK - I don't understand what you are trying to do - sorry.
[sw]*[/sw]
Re: OFFSET formula to ignore cell with a blank formula
Hi,
That didnt seem to work, I have attached a sample worksheet, with the named range, the named range is selecting everything until the last formula and not just the first line.
Thanks
Re: OFFSET formula to ignore cell with a blank formula
Hello again,
Quote from Nagin;796347I would like to select the range until there is a blank return on the formula in column B.
If this is your request ... believe formula in post #5 does perform as requested ...
HTH
Don’t have an account yet? Register yourself now and be a part of our community!