Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have 4 columns in a spreadsheet that are formatted for drop down options.
I am interested in restricting the selection of options previously selected so as to eliminate double entries. How do I do this? Any suggestions will be greatly appreciated |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
See this:
http://contextures.com/xlDataVal03.html -- Biff Microsoft Excel MVP "Neal" wrote in message ... I have 4 columns in a spreadsheet that are formatted for drop down options. I am interested in restricting the selection of options previously selected so as to eliminate double entries. How do I do this? Any suggestions will be greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I include a "validation drop down" in a conditional statement? | Excel Worksheet Functions | |||
Conditional Statement using a Drop down box | Excel Worksheet Functions | |||
Need conditional statement to paint a cell | Excel Discussion (Misc queries) | |||
Need conditional statement to paint a cell | Excel Worksheet Functions | |||
Nest IF statement workaround | Excel Worksheet Functions |