@samir sir, i am not comparing two excel sheet, instead my use case is below -
1st excel with records but my prime focus is Description column
2nd excel with keywords(in the excel there is one column keywords, i have to use these column and filter which contains the keywords in the excel1 Description column)
write 2 excel, one with filtered record and 2nd with rest of the records.
I am attaching sample excel filekeywords.xlsx (7.2 KB) records.xlsx (8.6 KB)