This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Comparing Lists and Removing Values

Posted on 03-14-2019 01:50 PM
Rich_E
Staff
Reply posted on --/--/---- --:-- AM

How would I create a valid_if formula to compare 2 lists and then remove values that exist or do not exist in another list?

For example, I have List A and List B. I want to use a valid_if to only allow entries that “do not” exist in List B but exist in List A.

Solved Solved
0 1 1,306
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
tony1
New Member
Reply posted on --/--/---- --:-- AM

You could try this: [List A] - [List B]

See “List Subtraction” here: https://help.appsheet.com/expressions/expression-types/list-expressions-and-aggregates

View solution in original post

Jump to Solution
1 REPLY 1
Top Labels in this Space