Oct 02 2024 08:34 AM - edited Oct 02 2024 08:37 AM
I have sheet A that has 3000 rows of data, and I have sheet B that has 1000 rows of data. I want to copy all data from sheet A to a new sheet, sheet C, but exclude all rows that are in Sheet B. Sheet B consists of data that is in sheet A that I do not want in there so I'm not sure the best way to exclude/filter that sheet B data out. Any help is appreciated, thank you!
i.e. if sheet C includes any data from sheet B, remove/do not include that row.
Oct 02 2024 09:00 AM
SolutionLet's assume that you want to exclude rows that match on column A.
In A2 on Sheet C:
=FILTER('Sheet A'!A2:Z3000, ISNUMBER(XMATCH('Sheet A'!A2:A3000, 'Sheet B'!A2:A1000)))
Adjust the sheet names and the ranges as needed.
Oct 02 2024 09:26 AM
Oct 02 2024 09:00 AM
SolutionLet's assume that you want to exclude rows that match on column A.
In A2 on Sheet C:
=FILTER('Sheet A'!A2:Z3000, ISNUMBER(XMATCH('Sheet A'!A2:A3000, 'Sheet B'!A2:A1000)))
Adjust the sheet names and the ranges as needed.