# Thread: Formula for combining numbers from 2 tables

1. ## Formula for combining numbers from 2 tables

Register for a FREE account, and/
or Log in to avoid these ads!

Dear Forum Users,

In the uploaded xls. file there is a table titled: ALL possible combinations of NUMBERS(AZ13:BE22). In this table I would like for combinations of NUMBERS to appear after the comparison of the two SET combinations. This means that in the number combinations there shall be numbers from:

• Identical numbers with 2nd combination plus green (Tab. 1) (BA6:BE11) and
• Identical numbers with 1st combination plus green (Tab. 2) (BA27:BE32)

This is a graphic demonstration how the formula should make the combinations of numbers:
Attachment 10497

Basically a number from each SET, must be in the NUMBER combination. Also, maximally, only, one number from each set must be used. In this example I used yellow background to show that in each set of both SET combinations there is a number the forms the NUMBER combination: 1, 11, 24, 30, 31. Now, instead of 24, I could have also picked 8 and 45 and crossed out 24. Then the combination would consist of 6 numbers: 1, 8, 11, 30, 31, 45.

Any help would be appreciated Please dont hesitate do ask questions of something isnt quite understandable.

Cross posted at:
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/thread...ables.1170631/  Reply With Quote

2. UPDATE: I have a newer Excel version  the 365 one, not the 2016 anymore.  Reply With Quote

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•