| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a list where an item can only be picked once in Excel
I'm trying to set up a spreadsheet and I have a list where I would like items
picked only once. Once that item has been picked, is it possible for it not to reappear in the list in all the remaining cells in the range? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Setting up a list where an item can only be picked once in Excel
You can use data validation to do this.
Suppose the range of interest is A1:A5 Select the range A1:A5 Goto the menu DataValidation Allow: Custom Formula: =COUNTIF(A$1:A$5,A1)<2 OK out Whenever you attempt to enter a duplicate value you'll get a popup error message. Biff "J." wrote in message ... I'm trying to set up a spreadsheet and I have a list where I would like items picked only once. Once that item has been picked, is it possible for it not to reappear in the list in all the remaining cells in the range? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Setting up a list where an item can only be picked once in Excel
There are instructions here for hiding used items in a data validation list:
http://www.contextures.com/xlDataVal03.html J. wrote: I'm trying to set up a spreadsheet and I have a list where I would like items picked only once. Once that item has been picked, is it possible for it not to reappear in the list in all the remaining cells in the range? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
| How validation dropdown list open when cell is picked?. | Excel Worksheet Functions | |||
| If certain item is picked, then text added... | Excel Discussion (Misc queries) | |||
| Spell Checking - Special Words Not Picked Up by Excel | Excel Discussion (Misc queries) | |||
| Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions | |||
Hybrid Mode
