I've tried googling this for a few days and yet haven't been able to find an answer. I think part of the problem is I'm not too sure how to look for what I need.
Anyway, I hope I can explain this.
So say in box B1 =MIN(1,A5)
Now in box B2 I need =MIN(2,A5)
but copying and pasting it makes it =MIN(1,A6)
So is there a way for me to copy and paste this so each time the number increases by 1 but the mentioned cell (A5) stays the same? I need to have this going up to 900 so can't really do it by hand.
I have tried other ways of trying to make this work. One was doing the following.
Cell B1 =Min(1,A5)
Then in Cell B2 =min(B1+1,A5)
So each time I copy and paste this the B1 would go up by one but this still causes the problem with the A5 cell as that goes up by 1.
I hope you can understand what I'm looking for and thanks to anyone that can help. ^_
Anyway, I hope I can explain this.
So say in box B1 =MIN(1,A5)
Now in box B2 I need =MIN(2,A5)
but copying and pasting it makes it =MIN(1,A6)
So is there a way for me to copy and paste this so each time the number increases by 1 but the mentioned cell (A5) stays the same? I need to have this going up to 900 so can't really do it by hand.
I have tried other ways of trying to make this work. One was doing the following.
Cell B1 =Min(1,A5)
Then in Cell B2 =min(B1+1,A5)
So each time I copy and paste this the B1 would go up by one but this still causes the problem with the A5 cell as that goes up by 1.
I hope you can understand what I'm looking for and thanks to anyone that can help. ^_