Results 1 to 12 of 12

Unique Values in Dynamic Down List

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2019
    Location
    Miami
    MS-Off Ver
    365
    Posts
    69

    Question Unique Values in Dynamic Down List

    Hello,

    I'd like to automatically populate a drop-down list with the unique values contained in a table's column using the value of another column. So if my table looked like this:

    REGION OFFER
    North Learning Tools
    North Learning Tools
    North New Offers

    I'd want the drop-down list to only show "Learning Tools" and "New Offers" when "North" is selected in a different cell (the attached table shows other regions). It would be great if the drop-down list is sorted - but not mandatory.

    Is this possible without macros/VBA?

    Thanks
    Attached Files Attached Files
    Last edited by philchi; 07-28-2019 at 04:28 PM. Reason: Updated spreadsheet

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] dynamic and dependent drop down list with unique values
    By Villalobos in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2019, 03:50 PM
  2. [SOLVED] Create a list of unique values from several columns in a dynamic table.
    By schurchill39 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-28-2018, 06:51 PM
  3. [SOLVED] Get list of unique values from dynamic range
    By BG1983 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-09-2018, 02:15 PM
  4. dynamic list of unique values
    By td3201 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-14-2017, 12:38 AM
  5. [SOLVED] Dynamic Unique List from multiple dynamic columns
    By JO505 in forum Excel General
    Replies: 7
    Last Post: 06-11-2015, 05:41 PM
  6. [SOLVED] List unique values from multiple dynamic lists
    By andredl in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-22-2014, 02:37 AM
  7. Create unique list from dynamic list with dupes
    By kfryar in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-10-2014, 09:20 PM

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