deciog Active Member Apr 18, 2016 #26 Mr.Karr, In column E2 and F2 CTRL + Enter + Shif, it is matrix, gives it worked. Decio in Brazil excuse, using Google Translate, and not speak or write in English.
Mr.Karr, In column E2 and F2 CTRL + Enter + Shif, it is matrix, gives it worked. Decio in Brazil excuse, using Google Translate, and not speak or write in English.
B bosco_yip Excel Ninja Apr 18, 2016 #27 Mr.Karr said: @bosco_yip, please recheck the attached file. I have encircled it as it shows 1 against mail but I do not have the keyword 'mail nowhere in the list. Please help. Click to expand... Formulae fixed in : =SUMPRODUCT(ISNUMBER(SEARCH(" "&A$2:A$5144&" "," "&SUBSTITUTE($D2&",",","," ")))*(A$2:A$5144<>"")) or, =SUMPRODUCT(ISNUMBER(SEARCH(" "&A$2:A$5144&","," "&$D2&","))*(A$2:A$5144<>"")) Regards Bosco Attachments SearchAnimalR2.xlsx SearchAnimalR2.xlsx 77.5 KB · Views: 4
Mr.Karr said: @bosco_yip, please recheck the attached file. I have encircled it as it shows 1 against mail but I do not have the keyword 'mail nowhere in the list. Please help. Click to expand... Formulae fixed in : =SUMPRODUCT(ISNUMBER(SEARCH(" "&A$2:A$5144&" "," "&SUBSTITUTE($D2&",",","," ")))*(A$2:A$5144<>"")) or, =SUMPRODUCT(ISNUMBER(SEARCH(" "&A$2:A$5144&","," "&$D2&","))*(A$2:A$5144<>"")) Regards Bosco
