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

Thread Tools
Display Modes


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 10:27 AM.


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