Good day!
I used the following formula to create a dynamic named range based on a PivotTable, but whenever I enter new information on the spreadsheet I get a circular reference error.
I put in the -2 due to the dropdown list showing an additional 2 blank spots that I don't need. Without the -2 I do not receive the circular reference error, but then the 2 blank spots show up in the dropdown list again. Can anyone help!
I used the following formula to create a dynamic named range based on a PivotTable, but whenever I enter new information on the spreadsheet I get a circular reference error.
Code:
=OFFSET('First Contact'!$I$6,0,0,COUNTA('First Contact'!$I:$I)-2,1)
I put in the -2 due to the dropdown list showing an additional 2 blank spots that I don't need. Without the -2 I do not receive the circular reference error, but then the 2 blank spots show up in the dropdown list again. Can anyone help!