Convuluted IF OR Syntax Puzzler

[stockgoblin42]

Hi,

I have 3 conditions that I just can't seem to set out properly in VBA. Wrap your puzzle solving brain around these:

- basically 3 sets of 5 variables each

At the end, one variable from each set must equal another variable from each set before proceeding.

I get the first 5 (A,B,C,D,E) then get another 4 (F,G,H,I), make sure one of the second set = one of the first set, get a J or if not then J must = one from the first set, get the last 4 (K,L,M,N) and make sure one from the third set = one from the second set, get an O or if not make O = one from the second set and make sure one from the third set = one from the first set, go ahead or if not, get a new N until one from the second set = one from the third set .........I think.

I have 15 simple variables DIM as Integer: A,B,C,D,E, F,G,H,I,J, K,L,M,N & O

So I believe I have to say:

if F,G,H or I aren't equal to A,B,C,D or E, J must be equal to A,B,C,D, or E
else
goto NEWJ
end if

if K,L,M or N aren't equal to A,B,C,D or E, O must be equal to A,B,C,D or E
else
goto NEWO
end if

if K,L,M, or N aren't equal to F,G,H,I or J, N must be equal to F,G,H,I or J
else
goto NEWN
end if


I'd ask Mr. Spock, but he's fictitious. I told Santa that and he slapped me in the face.

any help is appreciated

thanks

[millz]

try this. if it works, change it for the rest... sorry couldnt complete it as im typing off my phone.

Please Login or Register  to view this content.

[stockgoblin42]

Oh Oh,

I have an additional problem.

The 15 variables aren't derived from the same data set. There are two sets of data.

A,B, F,G & K,L are from one data set

C,D,E, H,I,J & M,N,O are from another data set

this complicates things because A can = 2 and C can = 2 but they're not = as they're from different data sets.

Hmmm, how am I going to deal with this too?

[millz]

? Sorry I don't understand what you mean. Maybe posting workbook example or someone else could help.