Forum Discussion
Xlookup or other formula help for copying data over but excluding specific data
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.
Let'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.
Let'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.
- Thank you! I was able to get it from this, appreciate it.
