Changing a range in a formula

[beverleypc]

Is there a way of changing the GMC range automatically for the formula below?

=DMIN('CEA - ALL'!$A$1:$O$1172,15,GMC!A1:A2)

When this is copied to the row below it updates to A2:A3 but I want it to change to A3:A4, A5:A6 etc

Is this possible?

 

[tyija1995]

The A1:A2 part of that formula is a relative reference, so if the cell is copied down 1 cell then it will augment the formula by 1 row hence the A2:A3 appears, to get A3:A4 you will have to copy it down 2 rows, similarly for A5:A6 you will have to copy it down 4 rows.