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!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

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.