Drop Down List Contains the List Header Row

#1 (**permalink**) 9th February 2010, 02:15 AM

------ Register to get rid of these "In Post" ads! ------

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
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-miscellaneous/177566-drop-down-list-contains-list-header-row.html#post637591
Data>Validation, 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 (**permalink**) 9th February 2010, 05:31 AM

------ Register to get rid of these "In Post" ads! ------

--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 Data>Validation>List>Source 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
> Data>Validation, the drop down list contains the header row name from A1.
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-miscellaneous/177566-drop-down-list-contains-list-header-row.html#post637714
> How can I keep the header row name from appearing as a choice in the drop
> down list?
>
> Thanks everyone for any help.

Thread Tools
Show Printable Version Email this Page Mark this thread as solved
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)