Apr 05 2022 11:27 AM
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!
Apr 05 2022 11:56 AM
=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.