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)