Hi,
I wanted to create 3 dependent lists. For example:
Col A Col B Col C
------ ------ ------
TaskA BAU Z101
TaskA PRJ Z002
TaskA PRJ Z003
TaskB BAU Y403
TaskB BAU Y407
TaskB BAU Y412

I need to find out what formula should I put in my data validation in Col B
so that when TaskA is selected, I will only see "BAU" and "PRJ", and if I
select BAU, only "Z101" will appear in the list (likewise if PRJ is selected,
Z002 and Z003 will be displayed.
When TaskB is selected, I will only see "BAU" once. I have tried to use
http://www.contextures.com/xlDataVal02.html
http://www.contextures.com/xlDataVal13.html
But cant get it to work. I can only get to the stage where BAU will appear 3
times.
Thank you so much in advance for your help.
Cheers!