Hi,
I have a excel sheet here with dynamic named ranged of a pivot table based on one column using the OFFSET formula in the Name Manager.
However, I would like to expand this dynamic named range for TWO columns. Been trying to get it to work using the OFFSET and MAX formula but can't seem to get it to work...
Can anyone help please? Please see attached file.
Thanks!!
TestFile3.xlsx
Hi Pho6,
The OFFSET Function has 4 arguments, Rows, Columns, Height & Width.
If you use a COUNTA Function in a Named Range for the Width & Height it will dynamically adjust the Range.
Have a look at this video of the method for auto updating charts - same principle;
http://www.youtube.com/watch?v=cYKqIYiuobQ
Remember you are unique, like everyone else
Got it - Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks