Forum Discussion
Comparing column data in Sheet 2 with column data in Sheet 3 in Excel365 on Windows
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 ...
=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.