| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pull down list and single value allowed
I have a column I want to prioritize from 1 to 11. I want to have those
values in a pull down list. I also want to only be able to use each value once, if the same value is used again I need it to use the new one and get rid of the old one. Any thoughts? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
pull down list and single value allowed
Debra Dalgleish shows how to do it he
http://www.contextures.com/xlDataVal03.html Hope this helps. Pete On Jul 2, 5:14*am, s v <s v @discussions.microsoft.com wrote: I have a column I want to prioritize from 1 to 11. I want to have those values in a pull down list. I also want to only be able to use each value once, if the same value is used again I need it to use the new one and get rid of the old one. Any thoughts? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull-down List | Excel Discussion (Misc queries) | |||
| single-cell multiple entry with pull-down list? | Excel Discussion (Misc queries) | |||
| Populating multiple cells from a single pull down | Excel Discussion (Misc queries) | |||
| Pivot Table List Detail from web should be allowed in Excel | Excel Discussion (Misc queries) | |||
| I cannot select a single cell or pull down cell contents | Excel Worksheet Functions | |||
Linear Mode
