Dear Reader,
Please see attached XLS file. In column D you'll notice that the drop down items show up under a number of blank fields.
I tried to fix this by means of an OFFSET function, which is:
=OFFSET('Types per manufacturer'!$A$2,0,0,COUNTA('Types per manufacturer'!$A:$A)-1,1)
This didn't work and I am wondering what I should do to fix this.
Thanks in advance for your advice.
Kind regards,
Victor
Bookmarks