Removing ColumnA from ColumnB, then presenting the results in ColumnC in Google Sheets-CodePudding

Home > Software design > Removing ColumnA from ColumnB, then presenting the results in ColumnC in Google Sheets

Removing ColumnA from ColumnB, then presenting the results in ColumnC in Google Sheets

Time：12-22

I have a Google Sheet with two columns: SetA and SetB. SetA contains values that must be removed from SetB, so that what I am left with is SetC, which contains ONLY values that are unique to SetB. Here is a copy of the file I've been beating my head against for the past few hours:

CodePudding user response：

You can try with this formula that finds with BYROW if there is a match in A or not:

=FILTER(unique(B2:B),BYROW(UNIQUE(B2:B),LAMBDA(each,IFERROR(MATCH(each,A2:A,0)=0,TRUE))))

Page link：https//www.codepudding.com/Softwaredesign/650684.html

Prev:Return Row Data if a Name is Found in a Column

Next:How Can I Make Cells Populate with Up-to-Date Information and still Work with My Existing Formula?

Tags：

google-sheetsgoogle-sheets-formula

Links：
CodePudding