kinkart Member Mar 31, 2017 #1 Hi, I'd like to know what is the formula I can use to automate column E in the exemple attached. I could try with a bunch of IF and OR, but is there something more elegant and less resource intensive that I could use? Thanks Attachments Book1.xlsx Book1.xlsx 8.4 KB · Views: 4
Hi, I'd like to know what is the formula I can use to automate column E in the exemple attached. I could try with a bunch of IF and OR, but is there something more elegant and less resource intensive that I could use? Thanks
B bosco_yip Excel Ninja Mar 31, 2017 #2 Please see attached file Regards Attachments Isnumber.xlsx Isnumber.xlsx 9.1 KB · Views: 9
J jayalaxmi Active Member Mar 31, 2017 #4 Hi Kinkart An another alternative if you want to try..Please find attached... Regards Jaya Attachments Copy of Book1.xlsx Copy of Book1.xlsx 8.9 KB · Views: 4
B bosco_yip Excel Ninja Mar 31, 2017 #5 Another shorter formula option, In F2, array formula ( by pressing SHIFT+CTRL+ENTER 3 keystrokes together) =OR(A2:D2=H$2:H$5)*(OR(A2:D2=I$2:I$5)+1)-1 and, F2 >> Custom Cells Format >> in the type box enter: "Good + Bad";"Bad";"Good"; All copied down. Regards Attachments Isnumber(1).xlsx Isnumber(1).xlsx 9.5 KB · Views: 4
Another shorter formula option, In F2, array formula ( by pressing SHIFT+CTRL+ENTER 3 keystrokes together) =OR(A2:D2=H$2:H$5)*(OR(A2:D2=I$2:I$5)+1)-1 and, F2 >> Custom Cells Format >> in the type box enter: "Good + Bad";"Bad";"Good"; All copied down. Regards
