![]() |
|
#1
|
|||
|
|||
![]()
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!!! |
#2
|
|||
|
|||
![]()
To be more specific I want the outcomes of the calculations:
50* 2=100 50* 3=150 50* 4=200 60* 2=120 60* 3 ... 60* 4 ... 70* 2 70* 3 70* 4 80* 2 80* 3 80* 4 Thank you Again!!! |
![]() |
Tags |
cartesian product, copy, sort |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
shilabrow | Excel Programming | 2 | 07-10-2014 11:09 AM |
![]() |
s7y | Excel | 13 | 05-15-2012 01:17 PM |
![]() |
ExecAssist | Mail Merge | 1 | 02-27-2012 04:06 PM |
How to remove background when copy and paste, no fill doesn't work. | mingo | Word | 1 | 07-29-2010 02:25 PM |
installing copy of XP prof. without product # | vicky | Office | 0 | 04-09-2006 07:16 AM |