http://j-walk.com/ss/excel/tips/tip47.htm
Filling a ListBox With Unique Items

From John Walkenbach's site.

--
Regards,
Tom Ogilvy

"Rory" wrote in message
...
A couple of questions regarding a spreadsheet I am
designing at the moment.

1. I have a combo box that is populated from sheet2 from
the range client, a client may have several entries in
this range, but I only want one occurence of each, can
this be done?
2. Once the client is chosen another combo box needs to be
populated based on the first combo box, again from sheet2,
with only that clients accounts, can this be done?

Regards

Rory