Forum Discussion
Solved
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...
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.