Drop down lists?

[Guest]

I've got a list of subjects, Maths, English, Science, Geography, PE, etc.

I want to set up a chart with 3 cells having a drop down box, with the list
in.

But, if I've selected one of the subjects in another cell, I want it
excluded from the list so I can't choose it twice.

Sorry for the rubbish explanation, I hope you get what I mean!

 

[Bernard Liengme]

No one seem to want to take this on.
Here is a work around: use Conditional Formatting to make cells red when
there are duplicates.
In XL2003 the Formula is can be
=COUNTIF($F$1:$H$1,F1)>1
where F1:H1 is the range with your values

In XL 2007 there is a simple step for highlighting duplicates - look at
Conditional Formatting in the Home tab
best wishes

 

[Gord Dibben]

Have a look at Debra Dalgleish's site for method and a sample workbook.

http://www.contextures.on.ca/xlDataVal03.html


Gord Dibben MS Excel MVP