Copy and past formula where only the numbers increase.

[Rojo1990]

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. ^_

 

[Tetra201]

Try this:

=MIN(ROWS($B$1:$B1),$A$5)