Dear all,

I would like to 'auto number' a column downwards.

It concerns the part B$1:B$2106;0), it should change to C, D and so forth when I 'drag down' the formula in the column.


=INDIRECT(ADRES(VERGELIJKEN($A$2;'Input Analytics'!B$1:B$106;0)+B$6;VERGELIJKEN($A8;'Input Analytics'!$A$1:$AA$1;0);;;$B$5))

Anyone any idea?

PS I am using the Dutch version of Excel so I suppose 'VERGELIJKEN' is 'COMPARE'