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!

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"SteW" wrote in message
...
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!

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

On Wed, 14 Nov 2007 04:43:01 -0800, SteW wrote:

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!