Hi everyone,
my problem is this:
I got some sheets with some numbers in each row and I want to find the right combination between them which use all of the numbers only one time each. I give you an example just to clarify:
Sheet 1
1,2,3,4
1,2,3,5
1,2,4,6
1,3,4,5
Sheet 2
1,2,5,6
5,6,7
6,4,7,8
1,6,7,8
2,5,6,8
Sheet 3
1,9,10,11
8,9,10,11
8,9,10,11,12
and I want in the result sheet
Sheet 1 - 1,2,3,4
Sheet 2 - 5,6,7
Sheet 3 - 8,9,10,11,12
that are one row from each sheet that use one number one time each and uses all the 12 numbers.
The constrict are that not in each row we have the same number of "numbers" and not in each sheet we have the same number of used rows.
Any help will be VERY appreciated!!
Bookmarks