Hi,

Iīm having a lot of trouble trying extract unique values and remove blanks from a list. I need the lists to update automatically so I canīt use autoformat.

Iīve used the following formula, which works great up to row 13. Simply changing the 13, to say 150, doesnīt work... Anyone have any idea?

{=OFFSET($A$1,MATCH(0,MMULT(--TRANSPOSE(TRANSPOSE($A$1:$A$13)=B$1:B1),ROW(INDIRECT("1:"&ROW()-1))/ROW(INDIRECT("1:"&ROW()-1))),0)-1,0,1,1)}

(Source: http://www.exceltip.com/st/Retrievin..._List/805.html)

Any help is much appreciated!

Thanks
Magsy