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!