Ignore Duplicate Entries on (dynamic) Data Validation List

[irmaosver]

First of all I would like to thank you in advance for taking the time to read my question, I have looked everywhere for a solution with no avail, without further ado, here is the problem:
Suppose we have three columns as below: (I am using Excel 2010)

Please Login or Register  to view this content.

As observed from the above, all columns may contain duplicates, the goal is to have three cells in a different sheet where data validation lists would be used. A typical scenario would be:
User selects the ID (e.g. 2), then on the next cell he selects the Sys (e.g. Roma), this list would be filtered according to the ID selected on the previous cell (only "Roma" and "Lima" shown), lastly, he selects the Code, this would be filtered according to the Sys selected (only "A5" and "A7" shown).
The approach which I am currently using is to have a separate list of only unique IDs, this is being used on the first validation list, then on the second validation list I am using the below formula to select the respective Sys:

Please Login or Register  to view this content.

Where IDS_Start is a reference to the first ID in my list, IDS a reference to the entire column ID and A1 is the cell in which the user selects the ID.
The problem with the above is that it will result in duplicates to be displayed on the second validation list, is there a way around this ? A helping hand would be much appreciated.

[Ron Coderre]

1) Welcome to the forum
2) This is a moderated forum so please read the forum rules at the above link
3) We require that if you post the same question to multiple forums, as you did with this post, that you include a link to the other forum posts. That way we can monitor progress in them and stop wasting our precious time if your issue has already been resolved elsewhere.
4) I'll post the link for you THIS time.
http://www.mrexcel.com/forum/excel-q...tion-list.html

[irmaosver]

Problem solved!