+ Reply to Thread
Results 1 to 5 of 5

drop down text formula

  1. #1
    Registered User
    Join Date
    12-15-2008
    Location
    England
    Posts
    2

    drop down text formula

    Hi
    Hope you can help.

    I currently have a spreadsheet that has a drop down box for 3 options of medium, large and extra large.

    When I select each one it shows me the list for each one, which is fine.

    However what I'm looking for is when I select large, it shows the large and the medium, and when I select extra large, it shows medium, large and extra large.

    Could you please advise on what kind of formula I can use to get this to work.

    Thanks

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    See if link helps

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

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Create one long list that shows all items in grouped together in some sort of ascending order...so that you can name each group + and use those...

    for example... if A1:A5 contains your "Small" items and A6:A10 contains the "Medium" and A11:A15 contains "Large", etc... then name ranges as follows.

    Name A1:A5 as "Small"
    Name A1:A10 as "Medium"
    Name A1:A15 as "Large"
    etc... (always starting from A1)

    then you can use the dependent drop down list formulal =Indirect(B1) where B1 contains initial selection of size.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  4. #4
    Registered User
    Join Date
    12-15-2008
    Location
    England
    Posts
    2

    drop down text formula

    Thanks for that.

    Would there be a different formula if there were spaces between some of the rows but did not want to show them when selecting the drop down?

    i.e

    medium
    (Blank Line)
    medium
    extra large
    large
    (Blank Line)
    (Blank Line)
    medium
    extra large

    Thanks

  5. #5
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    You would need to create a new column that redisplays your list without spaces and then use that column as a Named Range to point too for the drop down list.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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