

- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Hi airtable!
I have a list (an array) of items in two columns. Each row represents two different lists (one in each column). Iโd like to be able to compare the two columns and remove what is common in both. For example
Row 1:
Column 1: Apple, Orange, Pineapple, Kiwi
Column 2: Apple, Kiwi
Result: Column 3: Orange, Pineapple
Row 2:
Column 1: Banana, Orange, Grape, Kiwi, Pineapple, Passion Fruit
Column 2: Orange, Grape, Pineapple
Result: Column 3: Banana, Kiwi, Passion Fruit
etc.
The general functionality is to be able to compare (two or more arrays) and perform some kind of action.
Is this something that could be worked on?
Let me know if youโd like more details.
There are a few other posts here from people who have similar requests and ideas:
Removing specific values from arrays (this is mine in support)
Array intersect formula
Using Rollup to check on completed tasks?