# Dynamic Data Validation

1. ## 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  Register To Reply

2. ## Re: Dynamic Data Validation

You did not explain what that is supposed to do. Your link to the code cage gives non-members:

We only allow guests to see the first post of every thread to keep valuable resources for our members.
So....  Register To Reply

3. ## Re: Dynamic Data Validation

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

4. ## 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  Register To Reply