First you have to delete the duplicates then make your list from the remaining
suburbs.

Debra Dalgleish gives instructions for retrieving uniques from a list of
duplicates.

http://www.contextures.on.ca/xladvfi....html#FilterUR

DV lists do not enable autocomplete.

You need a combo box for this.

See Debra's site for this also.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben Excel MVP



On Thu, 24 Nov 2005 00:39:04 GMT, "eternal_cat via OfficeKB.com" <u14645@uwe
wrote:

K, I wanted it to contain only one instance of each suburb, whereas the list
is containing all the instances of the suburbs in the range that i have
selected. I also want to have this list so that it will autofill the suburbs
as i type them (since there is only one instance of each suburb). Like in
Excel help in the index when you type in a word and it automatically scrolls
down to a matching word.

thanks.


Easy.

Select the cell where you want to place the Drop Down.
From the Menu bar, select Data, then Validation.
On the Settings tab of the popup select List from the Drop Down.
Then click on the red arrow icon on the right side of the Source Box.
Now select the range of cells that contains your list.
Press Enter and click OK.

Hi, i was wanting to know how to make a drop down list for column F where the
contents of this list would be all the suburbs i had entered into that column
[quoted text clipped - 3 lines]

cat.