Hello
I have a set of characteristics in a defined horizontal range that needs to be shifted by a number of columns which is parameter driven. The formula needs to be copied across the table and down so it can pick-up any of the characteristics.
Example: the raising of a Purchase Orders triggers certain events for the completion of a build before customers can be acquired. If I delay the raising of the Purchase Order that would shift trigger events to the right of the spreadsheet.
I was trying yo use offset with this but seem unable to avoid gett
Example attached
Thanks in advance
Bookmarks