Thread: Drop Down List in Excel

Hello,

I need to analyse survey data in excel. I can make a drop down list in
Excel, via Validation, and get the option to enter one choice. However, one
question asks respondents to select "all" that apply.

I do not know how to do this, there are anything from one to six selections.
The ideal choice would be to be able to selct more than one rather than have
to enter each choice as a new column.

Any help would be much appreciated

Thanks

Sory, but that went over my head "completely" I dont know ! I have used A1 to
G1 and the formula / options for validation are somwhere else on the same
sheet. I just want to be able to select more than one option.

Thanks though ! but im still stuck

"Andyroo" wrote:

> Hello,
>
> I need to analyse survey data in excel. I can make a drop down list in
> Excel, via Validation, and get the option to enter one choice. However, one
> question asks respondents to select "all" that apply.
>
> I do not know how to do this, there are anything from one to six selections.
> The ideal choice would be to be able to selct more than one rather than have
> to enter each choice as a new column.
>
> Any help would be much appreciated
>
> Thanks

As answered in microsoft.public.excel.worksheet.functions:


You can do this with data validation and programming. There's a sample
file here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Select Multiple Items from Dropdown List'

Andyroo wrote:
> Hello,
>
> I need to analyse survey data in excel. I can make a drop down list in
> Excel, via Validation, and get the option to enter one choice. However, one
> question asks respondents to select "all" that apply.
>
> I do not know how to do this, there are anything from one to six selections.
> The ideal choice would be to be able to selct more than one rather than have
> to enter each choice as a new column.
>
> Any help would be much appreciated
>
> Thanks


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Debra,

Thanks, I will try that. If I get any problems I will come back

"Debra Dalgleish" wrote:

> As answered in microsoft.public.excel.worksheet.functions:
>
>
> You can do this with data validation and programming. There's a sample
> file here:
>
> http://www.contextures.com/excelfiles.html
>
> Under Data Validation, look for 'Select Multiple Items from Dropdown List'
>
> Andyroo wrote:
> > Hello,
> >
> > I need to analyse survey data in excel. I can make a drop down list in
> > Excel, via Validation, and get the option to enter one choice. However, one
> > question asks respondents to select "all" that apply.
> >
> > I do not know how to do this, there are anything from one to six selections.
> > The ideal choice would be to be able to selct more than one rather than have
> > to enter each choice as a new column.
> >
> > Any help would be much appreciated
> >
> > Thanks
>
>
> --
> Debra Dalgleish
> Contextures
> http://www.contextures.com/tiptech.html
>
>

Hi,

I can`t find "Select Multiple Items from drop down List", any other
suggestions ? I appreciate it

"Debra Dalgleish" wrote:

> As answered in microsoft.public.excel.worksheet.functions:
>
>
> You can do this with data validation and programming. There's a sample
> file here:
>
> http://www.contextures.com/excelfiles.html
>
> Under Data Validation, look for 'Select Multiple Items from Dropdown List'
>
> Andyroo wrote:
> > Hello,
> >
> > I need to analyse survey data in excel. I can make a drop down list in
> > Excel, via Validation, and get the option to enter one choice. However, one
> > question asks respondents to select "all" that apply.
> >
> > I do not know how to do this, there are anything from one to six selections.
> > The ideal choice would be to be able to selct more than one rather than have
> > to enter each choice as a new column.
> >
> > Any help would be much appreciated
> >
> > Thanks
>
>
> --
> Debra Dalgleish
> Contextures
> http://www.contextures.com/tiptech.html
>
>

Look at that page again, at that topic (Data Validation) and it's down in the
list if you scroll down about 1/3 of the way. You could do [ctrl]+F and
search for
Select Multiple Items from Dropdown List
on that page and it'll take you right to it. The link to the sample file is
this:
http://www.contextures.com/DataValMultiSelect.zip

"Andyroo" wrote:

> Hi,
>
> I can`t find "Select Multiple Items from drop down List", any other
> suggestions ? I appreciate it
>
> "Debra Dalgleish" wrote:
>
> > As answered in microsoft.public.excel.worksheet.functions:
> >
> >
> > You can do this with data validation and programming. There's a sample
> > file here:
> >
> > http://www.contextures.com/excelfiles.html
> >
> > Under Data Validation, look for 'Select Multiple Items from Dropdown List'
> >
> > Andyroo wrote:
> > > Hello,
> > >
> > > I need to analyse survey data in excel. I can make a drop down list in
> > > Excel, via Validation, and get the option to enter one choice. However, one
> > > question asks respondents to select "all" that apply.
> > >
> > > I do not know how to do this, there are anything from one to six selections.
> > > The ideal choice would be to be able to selct more than one rather than have
> > > to enter each choice as a new column.
> > >
> > > Any help would be much appreciated
> > >
> > > Thanks
> >
> >
> > --
> > Debra Dalgleish
> > Contextures
> > http://www.contextures.com/tiptech.html
> >
> >