I would like to create 2 droplist in the excel. The value of the droplist would be obtained from a table. The table would be in the following format:
A 2
B 7
A 12
C 8
A 9
B 15
B 17
So for the first droplist, I would like to have the values A, B, C for the user to select (without duplicate). The value of second droplist would then depend on what is chosen by the user in first droplist. For example, if the user chooses A in the 1st droplist, I would like to have 2,12, 9 in the 2ns droplist for the user to select. It is possible or difficult to do this?
Thanks
A 2
B 7
A 12
C 8
A 9
B 15
B 17
So for the first droplist, I would like to have the values A, B, C for the user to select (without duplicate). The value of second droplist would then depend on what is chosen by the user in first droplist. For example, if the user chooses A in the 1st droplist, I would like to have 2,12, 9 in the 2ns droplist for the user to select. It is possible or difficult to do this?
Thanks