any combination of this numbers
i need an column that say
when an 2 4 6 8 9 0 any combination from it is true
an d the same for 13 5 7 9
thnks in advanced!
when an 2 4 6 8 9 0 any combination from it is true
an d the same for 13 5 7 9
thnks in advanced!
Martin Liss
I'm pretty familiar with your workbooks but for everyone's benefit please attach a workbook.
And how is this different from your last question?
ASKER
ASKER
what i mean now is in one column have the word even or odd when any combination
of just this numbers
example : 2 4 6 8 0 any combination of just this numbers the word even appear in a column near
example 1 3 5 7 9 any combination of these number trigger the word odd
but have to be any combination of just these number
not mix of even and odd like the funtion make for example 2369 not word appear
of just this numbers
example : 2 4 6 8 0 any combination of just this numbers the word even appear in a column near
example 1 3 5 7 9 any combination of these number trigger the word odd
but have to be any combination of just these number
not mix of even and odd like the funtion make for example 2369 not word appear
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Subodh Tiwari (Neeraj) Great solution !!
Martin working perfect !
Martin working perfect !
You're welcome Adriana!
ASKER
Thanks Gentlemen to 2 Great Experts !