Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula reflecting mutliple results | Excel Discussion (Misc queries) | |||
Stacked Column graphs reflecting net totals | Charts and Charting in Excel | |||
Master Worksheet reflecting sub-worksheets | New Users to Excel | |||
Maintain mutliple original formats in a formula result | Excel Worksheet Functions | |||
Continued.....answer 8 - 1.2 = 6.2 from a formula | Excel Worksheet Functions |