Hi Everyone,

I need help on search functions in excel. I have two (2) files with one similar column header (TASK_NO). I need to identify from Sheet-A all rows that have the same value (col header TASK_NO) as those from Sheet-B TASK_NO.

Goal is for me to remove all rows from Sheet-A that are like/similar to those from Sheet-B, using TASK_NO column as identifier.

Thanks in advance!

Ladron