I'm trying to create column where there are hundreds of items in a and b column, and I want to remove common items in b column and list them in different column in excel or google sheet.
| a | b | items present in b column only |
|---|---|---|
| a1 | a1 | a5 |
| a2 | a2 | a6 |
| a3 | a5 |
|
| a4 | a6 |
CodePudding user response：
Excel:
Formula in C2:
=FILTER(B2:B5,COUNTIF(B2:B5,A2:A5)=0)
Google-Sheets:
Almost the same, but less explicit: =FILTER(B2:B,COUNTIF(B2:B,A2:A)=0)