Compare 2 lists of users/people


I tried to look a bit for an answer but I wasn’t able to get something working.

I have on a table 3 columns. The first 2 i fill manually.

First column is a list of people/user in each row
Second column contains some of the users appearing in the first column.

Now i want to display on a third column the users who are on the first column but not on the second one.

Would you be so kind to help me construct a formula for that ?

Thank you for your help.

hi yes it’s possible, try this :

FirstColumn.filter( currentValue.contain(SecondColumn).not())

Perfect it works fine now, thank you

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.