Filtering for unique values in a fixed number randomized list to get one of each
I have a group of 40 people who will meet with another member in that same group based on a random selection.
I created two tables with the same 40 people alphabetized and the same serial number ID from 0 to 39.
A looping Random script function on a List view layout creates the equivalent of:
John Doe meets with Peter Pepper
Peter Pepper meets with John Doe etc.
Until the number of meetings is created.
What I need to do and haven't figured out is how do I create 40 meetings but each record that will show in the list view only has one each of the member ID or numbers 0 thru 39, since they are randomized.
I have the feeling that I need to do many, many loops and eliminate duplicates until there are only one of each. I just don't know how to do the process to keep it going until there is actually one of each in each column of members.