Drop down with Validation

[Sodslaw]

Guys I have on column A a combo box (drop down box) that gets it data from a column on another sheet.
I did this via Data>Data validation> criteria List and entering the Source Data.

This is all fine, the issue I’m having is that I don’t want any duplicates in column A

>> How can i achieve this?

 

[bob fitz]

Set the Indexed property of column A to: Yes (No Duplicates) in the table properties.

 

[Minty]

In Excel : I'm not sure you can other than by making your lookup list dynamic to not include any existing entries?

 

[bob fitz]

Set the Indexed property of column A to: Yes (No Duplicates) in the table properties.

Sorry, I didn't notice that the question was in the Excel forum

 

[Sodslaw]

In Excel : I'm not sure you can other than by making your lookup list dynamic to not include any existing entries?

Thanks Minty, How would i do that?

 

[Sodslaw]

Sorry, I didn't notice that the question was in the Excel forum

No problem, thanks Bob.

 

[Minty]

Thanks Minty, How would i do that?

Good question, and probably beyond my Excel expertise I'm afraid.

It would be simple in Access as you could join the new data to the look up data and query it with a not equal join, and simply refresh after each entry.

I do vaguely remember working something out like this in Excel before, and seem to remember the formula was about 300 characters long.
Pretty sure I don't have it lying around any more.