Hello everyone,

I need your help!

I have 2 columns in a table. I would like to populate each column in the validation list.

Example:
Col1 Col2
A 1
A 2
A 3
B 4
B 5
C 6
C 7
C 8
C 9

I would like to put the 1st column in the 1st validation list without duplicates. If for example, A is selected, the second validation list will only show 1,2,and 3. Is this possible? Could you please provide an sample formula?

Your help on this is appreciated.

Statsman