| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List Contains the List Header Row
Hello,
I've created a list that contains a header in A1 on a separate worksheet within the same workbook. When I created the drop down list using DataValidation, the drop down list contains the header row name from A1. How can I keep the header row name from appearing as a choice in the drop down list? Thanks everyone for any help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down List Contains the List Header Row
--In source mention the formula as $H$2:$H$10
--If you want to create a dynamic named range as below.. Enter the below formula in DataValidationListSource to have the list from H2 to Hn where Hn is the last entry in that column...... =OFFSET($H$2,,,COUNTA($H:$H)-1) -- Jacob "Glenn" wrote: Hello, I've created a list that contains a header in A1 on a separate worksheet within the same workbook. When I created the drop down list using DataValidation, the drop down list contains the header row name from A1. How can I keep the header row name from appearing as a choice in the drop down list? Thanks everyone for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
| Validation drop down list header problem | Excel Discussion (Misc queries) | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| How do I delete the drop down list of header / footer options in e | Excel Discussion (Misc queries) | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Linear Mode
