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
Bookmarks