This is one of those (hopefully) endless posts. There are quite a few GREAT methods in here to create a list of unique items, including pure formula approaches, VBA, SQL, among others...

Many thanks to everyone who has contributed in there:

http://www.mrexcel.com/board2/viewtopic.php?t=8659