I have a set of data with two columns. The data can repeat itself in both
columns. Ex:
A 1
A 2
A 3
B 3
B 4
B 5
I want to have the second column(1,2,3,4,5) as the source for a drop down
list but I want to be able to limit the values by the data on the first
column. Ex. I choose A and the list of possible values should be 1,2 and 3
whereas when I choose B the possible values should be 3, 4 and 5. Your advise
is very much appreciated.