SOLVED

Xlookup or other formula help for copying data over but excluding specific data

Copper Contributor

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.

2 Replies
best response confirmed by jimmy2335 (Copper Contributor)
Solution

@jimmy2335 

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.
1 best response

Accepted Solutions
best response confirmed by jimmy2335 (Copper Contributor)
Solution

@jimmy2335 

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.

View solution in original post