You must set up your dependent validation lists correctly. Iow, have a list
of ports, and a list of docks for each port. Your list of docks then has a
list of unique ports.
To call the dependent list, you use a formula. Say you select the port in
A1, and the dock in B1. In B1's data validation you use a formula
=INDIRECT(A1)

Easiest way is to have a horizontal list of ports, each with a vertical list
of docks referring to that port. You name the horizontal list Ports, and the
vertical lists you name as the specific port it refers to.
So, your validation list is from say A1:G1, and this has a range name of
Ports.
Say in A2:A10 you have a list of docks referring to a port called Sydney,
then you name range A2:A10 Sydney.

--
HTH

Kassie

Replace xxx with hotmail


"Ruth" wrote:

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