| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas with drop down menu
i need a formula so when if in a drop down menu that selection has already
been taken from another drop down menu i can place a message to say that the selection was already used/taken. thanks chris |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formulas with drop down menu
You can "remove" a selection from the list so that it can't be selected
again. See this for instructions: http://contextures.com/xlDataVal03.html -- Biff Microsoft Excel MVP "cele25" wrote in message ... i need a formula so when if in a drop down menu that selection has already been taken from another drop down menu i can place a message to say that the selection was already used/taken. thanks chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down menu | Excel Worksheet Functions | |||
| Drop Down Menu | Excel Discussion (Misc queries) | |||
| drop down menu | Setting up and Configuration of Excel | |||
| Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
| Drop Down Menu Help | Excel Discussion (Misc queries) | |||
Linear Mode
