Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-18-2017, 07:50 AM
kleanthis1 kleanthis1 is offline Copy, sort, remove doubles, Cartesian product Windows 8 Copy, sort, remove doubles, Cartesian product Office 2013
Novice
Copy, sort, remove doubles, Cartesian product
 
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
  #2  
Old 07-18-2017, 07:54 AM
kleanthis1 kleanthis1 is offline Copy, sort, remove doubles, Cartesian product Windows 8 Copy, sort, remove doubles, Cartesian product Office 2013
Novice
Copy, sort, remove doubles, Cartesian product
 
Join Date: Jul 2017
Posts: 7
kleanthis1 is on a distinguished road
Default Just to be more clear

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!!!
Reply With Quote
Reply

Tags
cartesian product, copy, sort



Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy, sort, remove doubles, Cartesian product Remove the * from the SubCate, Custom Sort, Replace..Help Please - I need. Thanks shilabrow Excel Programming 2 07-10-2014 11:09 AM
Copy, sort, remove doubles, Cartesian product How can I avoid doubles? s7y Excel 13 05-15-2012 01:17 PM
Copy, sort, remove doubles, Cartesian product Mail Merge Doubles My Document 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:18 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft