Hi all,
Im using a dynamic range with the equation underneath that brings up an error when i try to assign it to a pivot chart
=OFFSET(BrokerViewML!$A$1,0,0,COUNT(BrokerViewM!$F:$F)+1,7)
Now I have another equation for another pivot chart that references some other sheet that is working correctly!
=OFFSET(MasterList!$A$1,0,0,COUNT(MasterList!$F:$F)+1,7)
All I did was change the sheet name. (everything in the two sheets is the same except range size(for rows) and content)
the error equation seems to only highlight the first row with the headers in it but when I go to the equation through formula and click on it, the whole range that I want is highlighted.
Any ideas why this is happening?
Bookmarks