Hi I need the formulas in cells P6,R6 & T6 to move when I insert a new column to the left of O at the end of the month. the 3 month formula would move to look at cells. M6 to O6 rather than L6 to N6. The twelve month would look at D6 to O6 rather than C6 to N6. the YTD would look at M6 to O6 rather than M6 to N6.
Any ideas on how to do this.returns.xlsx
Hi
You could try using an OFFSET() function. e.g. in P6
Formula:
Please Login or Register to view this content.
and similarly for the 12 month, obviously changing the -3 to -12
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi
Or in P6 :-
and in R6 :-
Please Login or Register to view this content.
both entered with Control-Shift-Enter.Please Login or Register to view this content.
hth
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks