Hello every one kindly assist me in modifying the research equation in the file
Provided that the result is as explained in the file ... for example, if the sentence in any cell in column X is 10$ Discount AS PER MR.M.Zaid
So I want the result of the equation to be in the corresponding cell in column X only 10$ Discount Not all of this sentence is in column X
Thank you very much, and God bless you
Code:
=IF(COUNTIF($AV$3:$AV$11,$M3)>0,"Shopping",IF(ISNUMBER(SEARCH({"*Discount*","*discount*","*CXL*","*cxl*"},X3)),X3,""))
So I want the result of the equation to be in the corresponding cell in column X only 10$ Discount Not all of this sentence is in column X
Thank you very much, and God bless you