S sguna1982 Member Sep 21, 2016 #1 Hi All, Find the value and take adjacent cell then update the next cell based on adjacent value. Sample file attached. Thanks. Attachments test.xlsx test.xlsx 8.4 KB · Views: 5
Hi All, Find the value and take adjacent cell then update the next cell based on adjacent value. Sample file attached. Thanks.
B bosco_yip Excel Ninja Sep 21, 2016 #2 Try…….. In C2, formula copy down : =IF(ISNUMBER(SEARCH("case creation",A2))+COUNTIF(B$1:B1,B2)>0,"Blank","Non blank") Regards Bosco
Try…….. In C2, formula copy down : =IF(ISNUMBER(SEARCH("case creation",A2))+COUNTIF(B$1:B1,B2)>0,"Blank","Non blank") Regards Bosco
S sguna1982 Member Sep 21, 2016 #3 Excellent, Thanks for your immediate response. I need one more action should be check and update. Excel attached. Attachments test.xlsx test.xlsx 9.2 KB · Views: 6
Excellent, Thanks for your immediate response. I need one more action should be check and update. Excel attached.
B bosco_yip Excel Ninja Sep 21, 2016 #4 Try, =IF(ISNUMBER(SEARCH("case creation",A2)),1,IF(COUNTIF(B$1:B1,B2)>0,0,"Non blank")) Regards
