Good afternoon everyone
I have a sheet using multiple drop down selections, drawing the data from named ranges.
I am looking for a way to remove duplicate entries in the drop down selections so they only show one of each option, even though the data set it is drawing from must contain multiples of each option.
See attached: Cells I2 is the initial data set, and J2 has selection criteria dependant on the value in I2.
Both the I2 and J2 drop down boxes have multiples of the same entry, as it is not until K2 that a unique identifier is found.
What i am looking for is the drop down in both I2 and J2 to only have one of each entry..
Is there a way to do this via formula? or do i need to use a seperate reference list as my data validation? I am hoping not as this would mean constantly updating this seperate list as new entries are added, as opposed to it automagically (not a typo!!) updating.
Thanks in advance
Darren.
Bookmarks