Check the cell contain some keyword

Hi everyone.

I have hard exercise , pls support me this case.

After scrapt data from website and save into the excel file as attached file. I want to check row by row, if the row contain some keyword1 or keyword2 in the Sheet2 column A & B… then it will input the number “1” into the sheet1 column C & D.

Pls kindly support me with a xaml file.

Thanks in advance.
file.xlsx (10.0 KB)


I have solved the above assignment. Please find the attachment and Output and mark this as Solution so that it would help others and would be grateful.file.xlsx (10.5 KB)
Sequence.xaml (10.0 KB)


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.