Copy row references in array formulae

[Mike Baker]

I have a line of code that contains:

(INDEX($AK$1:$AL$999,SMALL(IF($AL$1:$AL$999=A2,ROW($AL$1:$AL$999)),ROW(1:1)),1))

I want to copy this formula down many rows so A2 becomes A3, A4 , etc. but ROW(1:1) stays absolute at ROW(1:1) and does not automatically index to ROW(2:2), (3:3), etc.

Any ideas would be appreciated.

Thanks.


Mike

 

[Jonmo1]

Try
ROW($1:$1)

 

[Mike Baker]

Thanks very much - that's brilliant!


Mike