I have an Excel file with and image of Sheet1 attached below.
I am trying to create a named range with a formula. I would like to set the range from cell A2 till the last row in Column A. I attempted to set the following formula in the Formulas-Define Name-Define Name section.
=OFFSET(Sheet1!$A$2,0,0,COUNTBLANK(Sheet1!$A:$A)+COUNTA(Sheet1!$A:$A)-1,1)
But this does not seem to set the range correctly. Any suggestions on how to resolve this?
I am trying to create a named range with a formula. I would like to set the range from cell A2 till the last row in Column A. I attempted to set the following formula in the Formulas-Define Name-Define Name section.
=OFFSET(Sheet1!$A$2,0,0,COUNTBLANK(Sheet1!$A:$A)+COUNTA(Sheet1!$A:$A)-1,1)
But this does not seem to set the range correctly. Any suggestions on how to resolve this?