+ Reply to Thread
Results 1 to 3 of 3

Dynamic Data Validation List

  1. #1
    Registered User
    Join Date
    10-22-2018
    Location
    Turkey
    MS-Off Ver
    Office2010
    Posts
    79

    Question Dynamic Data Validation List

    Hi All,

    My example excel file is attached. As being seen from attached file, I have 2 ranges to consist Data Validation Lists but the 2nd Validation List must be dynamic regarding the selection from the 1st Validation List has been tried to be explained in excel file.

    What can be the proper formulas to implement Data Validations' Lists of 1 & 2 ? Thanks in advance for kindest supports.
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    4,481

    Re: Dynamic Data Validation List

    Please try at H1 for unique list
    =IFERROR(INDEX($C$5:$C$999,AGGREGATE(15,6,ROW($C$5:$C$999)-ROW($C$4)/(FREQUENCY(MATCH($C$5:$C$999&"",INDEX($C$5:$C$999&"",),),ROW($C$5:$C$999)-ROW($C$4))>0)/($C$5:$C$999<>""),ROWS(H$1:H1))),"")
    drag down

    You may use remove duplicate or Advance filter for unique list.



    Data Validation Lists for
    B1
    =OFFSET($H$1,,,COUNTIF($H$1:$H$5,"*?"))

    Data Validation Lists for
    B2
    =OFFSET($A$4,MATCH(B$1,$C$5:$C$999,),,COUNTIF($C$5:$C$999,B$1))
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-22-2018
    Location
    Turkey
    MS-Off Ver
    Office2010
    Posts
    79

    Re: Dynamic Data Validation List

    Dear Bo_Ry. Please grant my appreciation with lots of thanks. All the best

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dynamic data validation list
    By Imran/CVT in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-12-2019, 08:56 AM
  2. Dynamic data validation list
    By Imran/CVT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-12-2019, 06:43 AM
  3. [SOLVED] Dynamic data validation list
    By martix in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-16-2018, 01:54 PM
  4. Dynamic Data Validation List or ComboBox
    By mjo1983 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-06-2018, 12:56 PM
  5. Dynamic Data Validation List - 2 criteria
    By smartbuyer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2018, 05:14 AM
  6. [SOLVED] Dynamic Conditional Data Validation List
    By rackman70 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-13-2012, 11:14 AM
  7. Data Validation with Dynamic List using VBA
    By nivassrii in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2011, 01:13 AM

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