Hi everybody!
So I got a green (AZ5:BE11) and a red (AZ26:BE32) table. Both tables consist of 6 rows. Some of these rows are filled with numbers. I would like a formula to make combinations of these numbers following the step by step approach showed in the worksheet “combining numbers step by step” and also in the “step by step” attachment.
As you can see, the requirements for the combinations are that:
— There is a number form each row in both tables present
— There is maximally one number from each row in both tables present
Bookmarks