Hi,

I have a large list of account codes in column C, i.e:
410500
410500

410500
443000
443700
etc

What I'd like to do is next to it in column D have that same list, but without the duplicates or empty cells, (i.e. from small list above = 410500, 443000, 443700).

What formula might achieve this?
Thanks in advance.