Hello.

I have a named Range called 'nth_occurrence' where the formula is basically COUNTA($B$8:$B8)

I have another named range called 'EndRange' where PART of the formula consists of Rows(Pivot!$1:2).

Now, I want to change the value 2 with 'nth_occurrence' and it's giving me an error.

Does anyone knows how to change it?

PS: Even in the formula itself, it's not working