Formula reflecting mutliple results--continued
 

What formula to write on D column:
-To show €œfail€� when theres an €œa€� or €œx€� on any column of A, B & C.
-To show €œundefined€� when €œ?€� on any column of A, B, & C
-To show €œpass€� when only €œb€�, or €œc€� or €œe€� (not €œa€� or €œx€� or €œ?€�) on A, B
& C columns.

A B C D
a a x fail
c b a fail
e c b pass
a a fail
e e a fail
c b c pass
c b b pass
c b ? undefined
e ? undefined

Kevin, Dana and Dave thank you for your help. Ive put more conditions,
hopefully theres a way to come up with a formula.

--
Aline Yiu

Formula reflecting mutliple results--continued
 

With your posted data in A1:C9

D1:
=CHOOSE(MAX((COUNTIF(A1:C1,{"A","X","~?","B","C"," E"})0)*{3,3,2,1,1,1}+1),"No
Data","Pass","Undefined","Fail")
Copy that formula down through D9.

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

"Aline Yiu" wrote in message
...
What formula to write on D column:
-To show "fail" when there's an "a" or "x" on any column of A, B & C.
-To show "undefined" when "?" on any column of A, B, & C
-To show "pass" when only "b", or "c" or "e" (not "a" or "x" or "?") on A,
B
& C columns.

A B C D
a a x fail
c b a fail
e c b pass
a a fail
e e a fail
c b c pass
c b b pass
c b ? undefined
e ? undefined

Kevin, Dana and Dave thank you for your help. I've put more conditions,
hopefully there's a way to come up with a formula.

--
Aline Yiu

Formula reflecting mutliple results--continued
 

Hi Ron,

THANK YOU SO MUCH... It works like a charm. You are amazing wondering how
you come up somthing like this.

Have a great day,
Aline xxx

--
Aline Yiu


"Ron Coderre" wrote:

With your posted data in A1:C9

D1:
=CHOOSE(MAX((COUNTIF(A1:C1,{"A","X","~?","B","C"," E"})0)*{3,3,2,1,1,1}+1),"No
Data","Pass","Undefined","Fail")
Copy that formula down through D9.

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

"Aline Yiu" wrote in message
...
What formula to write on D column:
-To show "fail" when there's an "a" or "x" on any column of A, B & C.
-To show "undefined" when "?" on any column of A, B, & C
-To show "pass" when only "b", or "c" or "e" (not "a" or "x" or "?") on A,
B
& C columns.

A B C D
a a x fail
c b a fail
e c b pass
a a fail
e e a fail
c b c pass
c b b pass
c b ? undefined
e ? undefined

Kevin, Dana and Dave thank you for your help. I've put more conditions,
hopefully there's a way to come up with a formula.

--
Aline Yiu

Formula reflecting mutliple results--continued
 

Thanks for the kind words.....(That's one of my favorite "tricks")

--------------------------
Regards,

Ron
Microsoft MVP (Excel)

(XL2003, Win XP)
"Aline Yiu" wrote in message
...
Hi Ron,

THANK YOU SO MUCH... It works like a charm. You are amazing wondering
how
you come up somthing like this.

Have a great day,
Aline xxx

--
Aline Yiu


"Ron Coderre" wrote:

With your posted data in A1:C9

D1:
=CHOOSE(MAX((COUNTIF(A1:C1,{"A","X","~?","B","C"," E"})0)*{3,3,2,1,1,1}+1),"No
Data","Pass","Undefined","Fail")
Copy that formula down through D9.

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

"Aline Yiu" wrote in message
...
What formula to write on D column:
-To show "fail" when there's an "a" or "x" on any column of A, B & C.
-To show "undefined" when "?" on any column of A, B, & C
-To show "pass" when only "b", or "c" or "e" (not "a" or "x" or "?") on
A,
B
& C columns.

A B C D
a a x fail
c b a fail
e c b pass
a a fail
e e a fail
c b c pass
c b b pass
c b ? undefined
e ? undefined

Kevin, Dana and Dave thank you for your help. I've put more
conditions,
hopefully there's a way to come up with a formula.

--
Aline Yiu