Comparing column data in Sheet 2 with column data in Sheet 3 in Excel365 on Windows

Copper Contributor

I am trying to take each cell's data in Column A in Sheet 2 and compare each cell's data to the data in Column A in Sheet 3. If no match is found copy the entire row from Sheet 2 to Sheet 1 starting at row 2. Thank you in advance for any and all help!

1 Reply

@RadioRail 

=FILTER(Sheet2!1:21,COUNTIF(Sheet3!A1:A15,Sheet2!A1:A21)=0)

Maybe with this formula. The ranges can be adapted as required. In the attached example data is in ranges Sheet3!A1:A15 and Sheet2!A1:A21 and the entire filtered rows are pulled to sheet1.