I would-- but a have another validation list that works based on the
selection in this validation list. There are several different docks in each
port, so the first list is to select the port and the second on is to select
the dock that is located at the port selected. So if is delete the
duplicates I would ruin the next step in the data selection. Is there a way
without deleting the duplicates?
--
Thank-you!
Ruth


"Kassie" wrote:

Remove the duplicates?

--
HTH

Kassie

Replace xxx with hotmail


"Ruth" wrote:

Hi there

I have a worksheet that uses a validation list that has multiple entries of
the same thing, ei the validation list will have "Alpena" 4 or five times in
a row. I want each name just to show up once in the drop down box. Is that
possible, if so, how?


--
Thank-you!
Ruth