# Copy and past formula where only the numbers increase.

#### Rojo1990

##### New Member
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. ^_

### Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

#### Tetra201

##### MrExcel MVP
Try this:

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

Replies
10
Views
474
Replies
6
Views
305
Replies
3
Views
299
Replies
6
Views
216
Replies
5
Views
433

1,191,038
Messages
5,984,279
Members
439,881
Latest member
Amitoj95

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back