View Single Post
 
Old 07-18-2017, 07:50 AM
kleanthis1 kleanthis1 is offline Windows 8 Office 2013
Novice
 
Join Date: Jul 2017
Posts: 7
kleanthis1 is on a distinguished road
Default Cartesian Product

The Cartesian Product is the multiplication of all cells in one column with the ones on the other column. Lets suppose that G has the values in cells 50 60 70 80 and H column has the values in cells 2 3 4 .

The cartesian product in A colum that I want is:
50* 2
50* 3
50* 4
60* 2
60* 3
60* 4
70* 2
70* 3
70* 4
80* 2
80* 3
80* 4

Thank you Again!!!
Reply With Quote