Hello, I am struggling to write a VBA algorithm. Input: list of users (name and country) List of historical pair of users (month, Person 1 and his country, Person 2 and his country) Output: combination of possible pair of users. Condition two users composing a pair should not have the same country a pair cannot be composed by two users who were selected together in the past. See attached picture. Any idea how to do that in VBA? Thank you very much!

VBA - Create potential combination of users based on a list and two conditions

Hello,

I am struggling to write a VBA algorithm.

Input:
- list of users (name and country)
- List of historical pair of users (month, Person 1 and his country, Person 2 and his country)
Output:
- combination of possible pair of users.
Condition
- two users composing a pair should not have the same country
- a pair cannot be composed by two users who were selected together in the past.

See attached picture. Any idea how to do that in VBA? Thank you very much!