Bit of an odd question here, but I'm totally stuck and can't seen to work out how to do this!
Basically I want to have a column set up with the following:
In cell A1 "=B1-B800"
In cell A2 "=B2-B799"
In cell A3 "=B3-B798"
And so on, until they meet around 400. I could write this out manually, but it would obviously take quite a while! So is there an automatic way to do this? I tried the standard click and drag down the column, but it just adds 1 to both references each time, which isn't what I need.
Any suggestions?
Basically I want to have a column set up with the following:
In cell A1 "=B1-B800"
In cell A2 "=B2-B799"
In cell A3 "=B3-B798"
And so on, until they meet around 400. I could write this out manually, but it would obviously take quite a while! So is there an automatic way to do this? I tried the standard click and drag down the column, but it just adds 1 to both references each time, which isn't what I need.
Any suggestions?