Create a 2nd drop list dependent of 1st drop list

[dungeon1976]

Hello,

I have a drop list that has several values (A1).

I want to create a second drop list on B1 which would have all the values that were used in the drop list on A1 except for the value that was chosen on A1.

Exemplifying:
Values for the drop list in A1:

• a
• b
• c
• d
• e
• f
• g
• h

What I want to do is that if I choose "d" at A1, the options of the drop list of B1 would only be:

• a
• b
• c
• e
• f
• g
• h

I don't know if I made myself clear on this problem. Perhaps it is a very simple problem. I don0t want to use VBA, just formulas, if possible.

Thanks in advance for all the help you may give me.

 

[t0azt]

This was the site I used when I was trying to do something similar. I dont know that a formula can do what you want.
http://www.contextures.com/xlDataVal02.html

 

[dungeon1976]

This was the site I used when I was trying to do something similar. I dont know that a formula can do what you want.
http://www.contextures.com/xlDataVal02.html

Thank you for the link, it gave me some ideas.
I have already managed to solve the problem. This is what I used:
I have created two source ranges, one for the drop list of A1 and one for the drop list of B1 at AI1 and AJ2, respectively.
At AI1 and down I put the list values I wanted.
At AJ1 I put: =IF(AI1=$A$1,AI2,AI1)
At AJ2 I put: =IF(IF(AI2=$A$1,AI3,AI2)=AJ1,AI3,IF(AI2=$A$1,AI3,AI2)) and copied down (with one less value than AI).

It worked.

Now I would like to know if is there any way I can make the second drop list only to be available AFTER the first drop list has an entered value. Any ideas?

Thanks.