+ Reply to Thread
Results 1 to 4 of 4

Depenedent dropdown list to work even if source data is unsorted

  1. 12-30-2015, 07:31 PM #1
    kosherboy
    kosherboy is offline
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Waterbury, CT
    MS-Off Ver
    Office 365
    Posts
    1,175

    Depenedent dropdown list to work even if source data is unsorted

    Hello,
    In this example workbook MainWkbk.xlsx i have a dropdown list dependent on another dropdown list with this formula situated in a defined name as "List":
    Please Login or Register  to view this content.
    The data validation dropdown list refers to the name "List".
    Problem i am having is that if the source range is sorted by column "B" instead of column "A" in sheet1 then the 2nd dropdown menu displays mostly irrelevant info?
    Is there any way around this?
    I greatly will appreciate any and all responses.
    Thanks in advance!
    Reply With QuoteRegister To Reply
  2. 12-30-2015, 07:59 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Depenedent dropdown list to work even if source data is unsorted

    When you sort the data on sheet1, sort by both column A AND column B. This keeps column A grouped the way is needed for your dependent drop downs, but then the secondary list itself will be alphabetized within that group.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 12-30-2015, 08:32 PM #3
    kosherboy
    kosherboy is offline
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Waterbury, CT
    MS-Off Ver
    Office 365
    Posts
    1,175
    Thanks but I have another dropdown based off the same source data which ideally i would like to be in alphabetical order by column B.
    Last edited by kosherboy; 12-30-2015 at 11:57 PM.
    Reply With QuoteRegister To Reply
  4. 12-31-2015, 09:55 AM #4
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Depenedent dropdown list to work even if source data is unsorted

    Then it is better to go for worksheet_event .
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Build list in Dropdown from Data source
    By aarbuckle in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-31-2009, 02:53 PM
  2. Build list in Dropdown from Data source
    By aarbuckle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2009, 02:47 PM
  3. work-around for "vlookup: with unsorted data
    By mark kubicki in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  4. work-around for "vlookup: with unsorted data
    By Roger Govier in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 07:05 AM
  5. work-around for "vlookup: with unsorted data
    By Roger Govier in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  6. work-around for "vlookup: with unsorted data
    By mark kubicki in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. [SOLVED] work-around for "vlookup: with unsorted data
    By mark kubicki in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-02-2005, 04:05 PM
  8. [SOLVED] Using INDEX w/MATCH to get data from unsorted source
    By Lynn Bales in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-22-2005, 11:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1