Results 1 to 7 of 7

Dependent Drop-down with Dynamic Named Ranges

Threaded View

  1. 12-14-2020, 02:15 AM #4
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: Dependent Drop-down with Dynamic Named Ranges

    Change range name typelist to

    =OFFSET(Lists!$B$4,1,MATCH(A2&"s",Lists!$C$4:$I$4,),COUNTIF(INDEX(Lists!$C$5:$I$105,,MATCH(A2&"s",Lists!$C$4:$I$4,)),"*?"))
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
« 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. Dependent List Validation from Dynamic Named Ranges
    By freeride in forum Excel General
    Replies: 11
    Last Post: 01-22-2020, 03:07 PM
  2. Dependent Drop-down menu without named ranges
    By olga6542 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-17-2019, 12:02 AM
  3. Dependent drop down lists -- without named ranges?
    By vicken_a in forum Excel General
    Replies: 3
    Last Post: 03-30-2018, 12:52 PM
  4. [SOLVED] Dependent data validation with dynamic named ranges
    By Ace_XL in forum Excel General
    Replies: 4
    Last Post: 08-07-2014, 10:02 AM
  5. [SOLVED] dependent drop down boxes and dynamic ranges
    By philcud in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 PM
  6. [SOLVED] dependent drop down boxes and dynamic ranges
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 09:05 AM
  7. [SOLVED] dependent drop down boxes and dynamic ranges
    By philcud in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1