Drop down lists?
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! |
Drop down lists?
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! |
Drop down lists?
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! |
All times are GMT +1. The time now is 10:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com