The OFFSET function returns a range based on a given starting point with a specified height and width (no of cells).
It’s a really useful formula for setting up dynamic ranges as you can vary the height and width on the result of another formula, in our example above this other formula is COUNTA which sets the height.
Please visit Stuff we use & recommend page to know more. You may also want to read about how you can use HTML and other codes to enhance your posts here: Enhance Your Posts Here. If you like story and want to be part of our community, please join us thru one of below links. Here is the same table with an additional week’s worth of course attendance data added.Refreshing the pivot table will not pull in the extra days data as the data range is still fixed.