Hi guys,

I want to create a drop down style Validation List from the following data set

Col G
row 20: OH
row 21: OH
row 22: OH
row 23: OH
row 24: UG
row 25: UG
row 26: SV

However I do not wish for the duplicate entries to be allowed. ie from the example above the list should have as selectable options: OH, UG, SV

The used range for these list varies - the list should be dynamic such that it will work until the next blank space is found in column G - perhaps using excel down function.

kind regards