Assume numbers from 1 to 8 in range B3:B10 and numbers from 9 to 16 in range C3:C10. The objective is to create all possible combinations in column E from these two ranges without using VBA (macros). This combined range of all possible combinations is called a Cartesian product. You may refer to the following steps […]
Read More →
Create all possible combinations from different ranges without using VBA
{ 124 Comments }