I have a spreadsheet that calcs the XNPV in each column.
I want the range to decrease by 1 in each column.
i.e. in A1, I want the range to be A5:A20.
in B1, I want the range to be A6:A20
in B3 I want the range to be A7:A20
Is there an easy way to do this?
The spreadsheet is quite big and I do not want to manually do it.
Thanks for any help!
I want the range to decrease by 1 in each column.
i.e. in A1, I want the range to be A5:A20.
in B1, I want the range to be A6:A20
in B3 I want the range to be A7:A20
Is there an easy way to do this?
The spreadsheet is quite big and I do not want to manually do it.
Thanks for any help!