Hi,

Please can you you show me how to write an OFFSET function that creates a dynamic range across columns/along a row rather than down a column/across rows.

For instance, how do I create a dynamic range that starts in c7 and expands along row 7 and stops short of the row Grand Total in the final column of the row ie I do not want the Grand Total to be included in the range.

Thank you for your help.