+ Reply to Thread
Results 1 to 7 of 7

Drop Down List in Excel

  1. #1
    Andyroo
    Guest

    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

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    maybe this would work,
    if your dropdown menu is in A1 and the formula is in B1
    =IF(A1="a",1,IF(A1="B",2,IF(A1="c",3,IF(A1="d",4,IF(A1="e",5,IF(A1="all",6,""))))))

    another way is to use a listbox in a userform and then you could have multi select
    Last edited by davesexcel; 06-26-2006 at 08:54 AM.

  3. #3
    Andyroo
    Guest

    RE: Drop Down List in Excel

    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


  4. #4
    Debra Dalgleish
    Guest

    Re: Drop Down List in Excel

    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


  5. #5
    Andyroo
    Guest

    Re: Drop Down List in Excel

    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
    >
    >


  6. #6
    Andyroo
    Guest

    Re: Drop Down List in Excel

    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
    >
    >


  7. #7
    JLatham
    Guest

    Re: Drop Down List in Excel

    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
    > >
    > >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1