excel dependant drop down boxes

[clocka]

Hi,

I'm quite good at excel but im stumped on this.

What I need is three drop down boxes.
each one has the same 7 dates listed.

what they are used for is to indicates preferences on dates to attend a course.
If one date is selected on the 1st dropdown box, it is then removed from the 2nd and 3rd drop down box. Then they will select one of the remaining dates in the 2nd drop down box and it removes that dates from the last drop down box.

I want to do this on a Form.

any advice? Ive googled but i dont think im searching for the exact phrase.

many thanks

 

[Jed Shields]

Sounds like you need an IF statement on List 2 items based on the result of List 1 eg:

Assuming the following:

Chosen date from List 1 is in A1
Chosen date from List 2 is in A2
Chosen date from List 3 is in A3
List 1 Dates are in B1 : B7
List 2 Dates are in C1 : C7
List 3 Dates are in D1 : D7

B1 : B7 are just typed in dates.

C1 : C7 and D1 : D7 are formula like below:

C1 ie the first date in List 2:
C1=IF(C1=A1,"",C1)
C2=IF(C2=A1,"",C2)
C3=IF(C3=A1,"",C3)
etc

And similarly for List 3:

D1 ie the first date in List 2:
D1=IF(D1=A2,"",D1)
D2=IF(D2=A2,"",D2)
D3=IF(D3=A2,"",D3)
etc

What this does is changes the Date value to a blank, so it's not there in the list. However, the blank can still be picked though.

It's not very pretty though.