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'
Bookmarks