How to compare 2 lists and only show users that are not in both

What I am trying to do is show all users that do not have a record in a 2nd list. So i guess the repeating group search on user table but how do i merger or intersect with users that are missing in 2nd table?

1 Like

You can do an advanced filter, and then filter when “not in” list 2.

1 Like

@NigelG I worked that out in my sleep last night which is simple solution and it works great. Thx for reply

This topic was automatically closed after 70 days. New replies are no longer allowed.