I am trying to figure out how to skip a cell when copying down a formula, I have to fill the formula down around 2000 rows to cannot do so manually. Specifically in cell B2 I have the formula:

INDEX(Sheet1!$BV$3:$BV$311,SMALL(IF($A2=Sheet1!$BV$3:$BV$311,ROW(Sheet1!$BV$3:$BV$311)-ROW(Sheet1!$BV$3)+1),ROW(1:1))))

I want to skip cell B3 and have the following formula automatically copied into cell B4:

INDEX(Sheet1!$BV$3:$BV$311,SMALL(IF($A2=Sheet1!$BV$3:$BV$311,ROW(Sheet1!$BV$3:$BV$311)-ROW(Sheet1!$BV$3)+1),ROW(2:2))))

What is happening now is I cannot get the ROW formula at the end from changing when I copy the formula down. So cell B4 is always coming up as:

INDEX(Sheet1!$BV$3:$BV$311,SMALL(IF($A4=Sheet1!$BV$3:$BV$311,ROW(Sheet1!$BV$3:$BV$311)-ROW(Sheet1!$BV$3)+1),ROW(3:3))))