bansche123
New member
- Joined
- May 11, 2021
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365 MSO (64bit)
[FONT="]Dear Forum Users,[/FONT]
[FONT="]In the uploaded xls. file there is a table titled: “[/FONT][FONT="]ALL possible combinations of NUMBERS”(AZ13:BE22)[/FONT][FONT="]. In this table I would like for [/FONT][FONT="]combinations of NUMBERS[/FONT][FONT="] to appear [/FONT][FONT="]after[/FONT][FONT="] the comparison of the [/FONT][FONT="]two SET combinations[/FONT][FONT="]. This means that in the number combinations there shall be numbers from:[/FONT]
[/FONT]View attachment 10497
[FONT="]Basically [/FONT][FONT="]a number from each SET, must be in the NUMBER combination[/FONT][FONT="]. Also, [/FONT][FONT="]maximally, only, one number from each set must be used[/FONT][FONT="]. In this example I used yellow background to show that [/FONT][FONT="]in each set of both SET combinations[/FONT][FONT="] there is a number the forms [/FONT][FONT="]the NUMBER combination[/FONT][FONT="]: [/FONT][FONT="]1, 11, 24, 30, 31[/FONT][FONT="]. Now, [/FONT]instead of 24, I could have also picked 8 and 45 and crossed out 24[FONT="]. Then the combination would consist of 6 numbers: [/FONT][FONT="]1, 8, 11, 30, 31, 45[/FONT][FONT="].
[/FONT][FONT="]Any help would be appreciated [/FONT]
[FONT="]Please don’t hesitate do ask questions of something isn’t quite understandable.
Cross posted at:
[/FONT]https://www.excelforum.com/excel-formulas-and-functions/1348997-formula-for-creating-number-combinations-from-two-tables.html#post5515180 (last post)
https://www.mrexcel.com/board/threads/formula-for-combining-numbers-from-2-tables.1170631/
[FONT="]In the uploaded xls. file there is a table titled: “[/FONT][FONT="]ALL possible combinations of NUMBERS”(AZ13:BE22)[/FONT][FONT="]. In this table I would like for [/FONT][FONT="]combinations of NUMBERS[/FONT][FONT="] to appear [/FONT][FONT="]after[/FONT][FONT="] the comparison of the [/FONT][FONT="]two SET combinations[/FONT][FONT="]. This means that in the number combinations there shall be numbers from:[/FONT]
- “Identical numbers with 2nd combination plus green (Tab. 1)” (BA6:BE11) and
- “Identical numbers with 1st combination plus green (Tab. 2)” (BA27:BE32)
[/FONT]View attachment 10497
[FONT="]Basically [/FONT][FONT="]a number from each SET, must be in the NUMBER combination[/FONT][FONT="]. Also, [/FONT][FONT="]maximally, only, one number from each set must be used[/FONT][FONT="]. In this example I used yellow background to show that [/FONT][FONT="]in each set of both SET combinations[/FONT][FONT="] there is a number the forms [/FONT][FONT="]the NUMBER combination[/FONT][FONT="]: [/FONT][FONT="]1, 11, 24, 30, 31[/FONT][FONT="]. Now, [/FONT]instead of 24, I could have also picked 8 and 45 and crossed out 24[FONT="]. Then the combination would consist of 6 numbers: [/FONT][FONT="]1, 8, 11, 30, 31, 45[/FONT][FONT="].
[/FONT][FONT="]Any help would be appreciated [/FONT]
[FONT="]Please don’t hesitate do ask questions of something isn’t quite understandable.
Cross posted at:
[/FONT]https://www.excelforum.com/excel-formulas-and-functions/1348997-formula-for-creating-number-combinations-from-two-tables.html#post5515180 (last post)
https://www.mrexcel.com/board/threads/formula-for-combining-numbers-from-2-tables.1170631/