Results 1 to 11 of 11

Data Validation & Two selections from Two unique cells populating a third list

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2014
    Location
    TX
    MS-Off Ver
    Excel 2007
    Posts
    21

    Data Validation & Two selections from Two unique cells populating a third list

    What I have is a a pretty long data validation list for selection, in which one cell's DV list is populated by another. Simple stuff. Well, I'd like to have that one cell (J5) have its data validation list populated by the result of two selected values (and have duplicates removed).

    The formula I currently have for J5 is
    =OFFSET(Class_List!$D$1,MATCH(J2,Class_List!$D:$D,0)-1,1,COUNTIF(Class_List!$D:$D,J2),1)

    And can be seen here, as only options from J2 are included in the list.
    0c7e6eeaf3.png


    So I'd like to make a selection in J2 and J4, then have my J5 list include all (sans duplicates) of the yellow entries in the 2nd screenshot. Have I approached this in the wrong manner?
    3011ffb60b.png

    8e8dc9ee43.png


    *Edit* Here's my doc FE13 LAMS V_1_4.xlsm
    Last edited by Elieson; 07-02-2015 at 04:38 PM. Reason: added File

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple selections from data validation list
    By astasinim in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2015, 11:20 AM
  2. Validation of 3 Unique Random selections
    By BrianCob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2014, 03:17 AM
  3. [SOLVED] Based on two cells data validation list should be populated in third cell with unique vals
    By anchuri_chaitanya in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-13-2014, 03:21 PM
  4. [SOLVED] Data validation list - country names are selections but 2 digit codes need to be result
    By Grilleman in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-07-2014, 11:28 AM
  5. Multiple selections from a pick list - only unique selections (no repeats) ?
    By opsayo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2011, 06:25 PM

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