I have a rather large range that I am using to populate a validation list.
There are several duplicate entries. Is there some formula I can use that
will eliminate the duplicates in the drop-down menu on the validated cells?

Using Excel 2003

Thanks in advance!