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 →
Assume two workbooks named Book1.xls and Book2.xls. In Book1.xls, there is a sheet named Jan and in the Book2.xls, there is a worksheet named Feb. In both the worksheets – Jan and Feb, the following exist 1. Same number of columns on both worksheets; and 2. Same order of columns on both worksheets; and 3. Same spellings of […]
Read More →
{ 328 Comments }
Assume a workbook with two worksheets – Jan and Feb. In both the worksheets, the following exist 1. Same number of columns on both worksheets; and 2. Same order of columns on both worksheets; and 3. Same spellings of headings on both worksheets As you can observe in this workbook, all three aspects mentioned above […]
Read More →
{ 72 Comments }
Assume there is data in range A2:BG2185 of a worksheet (Range A1:O1 have headings). In column A are years and in column B are Countries. Other columns have some text/numeric data. In column A are years ranging from 1984 to 2009 for each country mentioned in column B. Therefore, Albania would appear in range B2:B27 and 1984-2009 […]
Read More →
Create all possible combinations from different ranges without using VBA
{ 124 Comments }