+ Reply to Thread
Results 1 to 4 of 4

Dynamic Data Validation

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Dynamic Data Validation

    I need to create a validation data with this function.
    = SUBSTITUTE (TRIM (IF (F2 = "", "", INDIRECT (F2)) & "" & IF (OR (F3 = F2, F3 = ""), "", INDIRECT (F3)) & "" & IF (OR (F4 = F2, F4 = F3, F4 = ""), "", INDIRECT (F4))), "", "")

    Cross-Post
    http://www.thecodecage.com/forumz/mi...-function.html
    Attached Files Attached Files
    Last edited by marreco; 05-22-2012 at 07:57 PM.
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Dynamic Data Validation

    You did not explain what that is supposed to do. Your link to the code cage gives non-members:
    Sorry but you need to register for FREE to see the rest of these posts. Please click HERE to register.

    We only allow guests to see the first post of every thread to keep valuable resources for our members.
    So....
    Ben Van Johnson

  3. #3
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Dynamic Data Validation

    I want the result of a formula in Data Validation List!

  4. #4
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Dynamic Data Validation

    Hello people!
    my friend NBVC excel expert, decided so splendid!

    Try this Non-VBA solution:

    Move the formula from G2 to another cell, say K2... then create a list using a formula and K2 result.

    So, in L2 enter formula:

    My Formula:
    =TRIM(MID(SUBSTITUTE($K$1,",",REPT(" ",100)),1+(100*(ROWS($A$1:$A1)-1)),100))



    and copy down as far as you need to make sure all possible entries A7:C7 are included.

    Then go to Formulas tab, then select Define Name, enter name like: MyList and then in the Refers to box enter formula:

    My Formula:
    =Plan1!$L$1:INDEX(Plan1!$L:$L,COUNTIF(Plan1!$L:$L,"?*"))



    Then use Data Validation with List choice in G2... and enter, in the source field:

    My Formula:
    =MyList

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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