You want to filter just the unique suburbs and paste that list to another
worksheet.

Your original data can remain untouched, duplicates and all.

Name the range of that list from the second sheet and use it for the drop-down
list which you place into the combo-box.

The combo-box allows auto-complete.

Debra's sites shows how to do both the above.


Gord Dibben Excel MVP

On Mon, 28 Nov 2005 02:21:00 GMT, "eternal_cat via OfficeKB.com" <u14645@uwe
wrote:

right, so i have to create a lookup sheet? I cant really delete the
duplicates, cos they are part of a valid record. Will all this help me to
have an autocomplete function in my suburbs column?

Gord Dibben wrote:
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

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
[quoted text clipped - 19 lines]

cat.