Dynamic Named Range - PivotTable

[sprigelz]

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.

=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!

 

[GlennUK]

Show a screen-shot of your error happening ... including the status bar at the bottom of the screen.