Remove Selected Item from list



I have an issue that I am trying to solve. I have three select lists
(supposed to be preference 1, 2,3) and each of them have the same three
options. As soon as I select one of the choices from list1, i would
like to remove it from the options of list 2 and so on for list 3.

So effectively, List 2 has two choices and List3 only has one choice
that can be made.

Any pointers on how to accomplish this?

.



Relevant Pages

  • RE: Formula for rating results
    ... Why do the Sum part, wouldn't that be just counting up a total. ... to generate your list of options in order of preference (this assumes ... example - first row going across lists all the options provided - there are ... for each name - going across have entered the rating given for an option 1 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Lost subcategories in List window
    ... I'm OS 10.4.10 and Entourage 2004 Version 11.3.3. ... Use relative dates in lists. ... The preference must have been reset or you have a corrupt preference file. ... Microsoft MVP ...
    (microsoft.public.mac.office.entourage)
  • Re: Lost subcategories in List window
    ... C2C0EA0D.106A1%jwasser@xxxxxxxxxxxxxxxxxxxxxxxx, "Joe Wasser" ... Use relative dates in lists. ... The preference must have been reset or you have a corrupt preference file. ... Entourage Help Blog ...
    (microsoft.public.mac.office.entourage)
  • RE: Formula for rating results
    ... to generate your list of options in order of preference (this assumes ... example - first row going across lists all the options provided - there are ... first column going down lists the poeples names ... for each name - going across have entered the rating given for an option 1 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Excel - Data Validation Question
    ... > I have setup 2 data validation lists: ... > How do I setup 2 further lists which act on that initial preference. ...
    (microsoft.public.excel.misc)

Loading