Closed

Combination Generator from a Matrix Table

Let's say, I've got an 3 x 3 matrix. I want all the combinations of the table entries such that, a combination

C1 = [R1C1] x [R2C1] x [R3C1]

C2 = [R1C1] X [R2C1] X [R3C2]

C3 = [R1C1] X [R2C1] X [R3C3]

C4 = [R1C1] X [R2C2] X [R3C1]

C5 = [R1C1] X [R2C2] X [R3C2]

C6 = [R1C1] X [R2C2] X [R3C3]

C7 = [R1C1] X [R2C3] X [R3C1]

C8 = [R1C1] X [R2C3] X [R3C2]

C9 = [R1C1] X [R2C3] X [R3C3]

C10 = [R1C2] X [R2C1] X [R3C1]

C11 = [R1C2] X [R2C1] X [R3C2]

C12 = [R1C2] X [R2C1] X [R3C3]

C13 = [R1C2] X [R2C2] X [R3C1]

C14 = [R1C2] X [R2C2] X [R3C2]

C15 = [R1C2] X [R2C2] X [R3C3]

....and so on. For a 3X3, there would a total of 27 combinations.

The algorithm should work for nxm matrix.

The matrix would be an input table in excel. The excel macro should generate these combinations and should display these combinations in a list below the table.

The output list will have 2 columns. 1st column will have combination Id, 2nd column will have the combination value. Combination Id is a string showing which positions were multiplied to get that combination. For eg. in the example above, the first combination id would be 1-1-1 and combination would be C1 value. next would be [1-1-2, C2], then [1-1-3, C3], [1-2-1 C4] etc..

Skills: Excel, Visual Basic

See more: random word combination generator, word combination generator, matrix table mysql, excel generate all possible combinations vba, excel all combinations of 3 columns, vba combination generator, list all possible combinations, excel permutation generator, excel combinations generator, excel all combinations of 4 columns, excel formula to find all possible combinations, excel, microsoft, mathematics, algorithm, matrix table design mysql, generator css table, matrix table design, combination generator wordlist, letternumber combination generator

About the Employer:
( 0 reviews ) Australia

Project ID: #17442971

20 freelancers are bidding on average $34 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$50 AUD in 0 days
(595 Reviews)
8.3
ksriniravi

Greetings! I can develop an Excel based Combination Generator for a n*m matrix as specified in requirements. Being a full time freelancer working exclusively on Excel based projects, I work on developing such excel More

$30 AUD in 1 day
(156 Reviews)
6.7
vano101

Hello I have over 17 years of experience in various areas of IT technologies and programming languages. Also, I have strong mathematical background and I have experience with writing Excel macros using VBA

$21 AUD in 1 day
(321 Reviews)
6.3
periyannas

Ok Sure ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ More

$82 AUD in 1 day
(40 Reviews)
5.1
$25 AUD in 1 day
(42 Reviews)
5.1
Ahmed818

hello, i am interested in this project can begin now , finish it in few hours waiting your answer Regards

$20 AUD in 0 days
(19 Reviews)
3.6
robcastillo

hi! I would like to help you with your project, please share with me a file with some matrix samples and I will check it. Best regards Roberto C.

$30 AUD in 1 day
(14 Reviews)
3.4
paulodayto08

I've been doing excel enhancement using vba macro for over 7 years now. and I am a subject expert matter and has a strong knowledge with MS excel. Please work with me, i can do than in less than a day. Also, current More

$15 AUD in 1 day
(2 Reviews)
1.3
$25 AUD in 2 days
(0 Reviews)
0.0
DataGuru2

Hi. Your explanation is absolutely clear. I think it can be done 100% . Let me know if you need me to do it.

$25 AUD in 5 days
(0 Reviews)
0.0
prabakarm23

Greetings for the Day!!!. I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv More

$83 AUD in 3 days
(54 Reviews)
0.0
$20 AUD in 1 day
(0 Reviews)
0.0
trebertm

I have made a proposal to you. An actual spreadsheet I made and ready for your review. If it's not what you have expected, please let me know so I can revise based on your need. If you want some features I can too. You More

$10 AUD in 1 day
(0 Reviews)
0.0
$25 AUD in 1 day
(0 Reviews)
0.0
schoudhary1553

Hi there, Warm Greetings We came along with your request for Combination Generator from a Matrix Table and we reviewed your project description. We'd like to help you with confidence and satisfying results. We More

$100 AUD in 1 day
(254 Reviews)
0.0
fastlabindia

We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, SI More

$10 AUD in 2 days
(0 Reviews)
0.0
nishantha041

Dear sir, By profession i’m an engineer and has sound knowledge about matrixes and its behavior.i can develop solution for this [login to view URL] contact me. Thank you.

$27 AUD in 2 days
(3 Reviews)
0.0
mirzasajed

I have a well experience in excel Work for others is a pleasure for me. I would not disappoint u. It would be a great honor for me to work for u.........I hope u will hire me for your project......

$30 AUD in 1 day
(3 Reviews)
0.0
$25 AUD in 10 days
(0 Reviews)
0.0
mhetre1s

I am an expert in Microsoft Excel Spreadsheet formulas and Visual Basic (VBA) programming for Excel files. I am willing to do the first project at low cost in order to demonstrate skills, earn good feedback and rec More

$25 AUD in 1 day
(0 Reviews)
0.0