Is there a way to drag and copy and automatically adjust cell references for the following expression as I describe below.
This formula is in Cell A7...
=ADDRESS(MIN(IF(A1:F6=A13,ROW(A1:F6))),MIN(IF(A1:F6=A13,COLUMN(A1:F6))),4)
When I drag it to Cell B7 I would like it to become....
=ADDRESS(MIN(IF(G1:L6=B13,ROW(G1:L6))),MIN(IF(G1:L6=B13,COLUMN(G1:L6))),4)
As you can see I would like A1:F6 to adjust to G1:L6 (By 6 cells) and A13 adjust to B13 (By 1 cell).
This formula is in Cell A7...
=ADDRESS(MIN(IF(A1:F6=A13,ROW(A1:F6))),MIN(IF(A1:F6=A13,COLUMN(A1:F6))),4)
When I drag it to Cell B7 I would like it to become....
=ADDRESS(MIN(IF(G1:L6=B13,ROW(G1:L6))),MIN(IF(G1:L6=B13,COLUMN(G1:L6))),4)
As you can see I would like A1:F6 to adjust to G1:L6 (By 6 cells) and A13 adjust to B13 (By 1 cell).
Last edited: