Excel formula

Fullført Lagt ut 6 år siden Betales ved levering
Fullført Betales ved levering

I have a spreadsheet that has many variables, and I want to create a formula that will multiply all the possible variable combinations onto a table.

For example:

Column A:

Text 1

Text 2

Text 3

Column B:

Text 1B

Text 2B

Text 3B

Column C:

Text 1C

Text 2C

Text 3C

Output:

Text 1 | Text 1B | Text 1C

Text 1 | Text 1B | Text 2C

Text 1 | Text 1B | Text 3C

Text 1 | Text 2B | Text 1C

Text 1 | Text 2B | Text 2 C

Text 1 | Text 2B | Text 3C

etc

There are 10 columns with a total of 38 variables giving a total possible combination of over 100,000.

I want a formula that will index all possible combinations into a table based on the user selection into the 10 columns. Formula preferred over Macros.

£15 for this quick help.

Algoritme Excel Microsoft Access Microsoft Office Word

Prosjekt-ID: #15320456

Om prosjektet

27 bud Eksternt prosjekt Aktiv 6 år siden

Tildelt til:

albertmakmur

Create formula to show combinations based on the user selection. Relevant Skills and Experience Microsoft Excel Formula Proposed Milestones £18 GBP - Until Done Additional Services Offered £1 GBP - None Have good k Mer

£18 GBP på 1 dag
(2 omtaler)
1.0

27 frilansere byr i gjennomsnitt £18 for denne jobben

someka

This is called combinations macro which I have done many similar ones before. Let me write on for you as well. Relevant Skills and Experience Excel VBA, mathematics Proposed Milestones £20 GBP - Job done I am online Mer

£20 GBP på 1 dag
(144 Omtaler)
7.1
katilinas

Hello, I can provide Excel VBA code to get total possible combination of over 100,000 from 10 columns with a total of 38 variables given. Relevant Skills and Experience Excel VBA Proposed Milestones £30 GBP - VBA for Mer

£30 GBP på 1 dag
(115 Omtaler)
6.4
bilalmaher053

hi i can do this right now for £15, and ready to start now, can you plaese send me excel file in PM? Relevant Skills and Experience excel Proposed Milestones £15 GBP - Payment No

£15 GBP på 1 dag
(145 Omtaler)
5.9
RRconsultant

Hi there, I am an excel expert and can help you with this. Look forward to hear from you. Thanks, RRC Relevant Skills and Experience . Proposed Milestones £20 GBP - Excel

£20 GBP på 1 dag
(40 Omtaler)
5.8
zu02

Hi, I can build that formula(with vba behind) Relevant Skills and Experience Access, vba, sql, ado, Excel Proposed Milestones £50 GBP - default

£50 GBP på 1 dag
(49 Omtaler)
6.1
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Accountancy, Administration and Content Writing experience with Advance MS Excel Dashboards, MS & Google Office, WordPress and Touch Typing 60wpm Skills Mer

£18 GBP på 2 dager
(21 Omtaler)
5.0
sharpzulfiqar

Hi Simple task for me as i am used to such tasks; Will be able to do in one hour after award. Warm Regards Z Relevant Skills and Experience Excel; VBA; Formulae Proposed Milestones £15 GBP - Final Deliverable

£15 GBP på 0 dager
(3 Omtaler)
5.1
haleem0786

i have good command over Ms excel especially pivot table, charts, advance formulas etc. Let me know more detail in PM Relevant Skills and Experience Ms excel Proposed Milestones £15 GBP - upon compeltion

£15 GBP på 1 dag
(14 Omtaler)
3.6
urko92

Hello, i read your full description and i am ready to this task. Relevant Skills and Experience I did MBA in finance and i am good with formulas. message me if you are interested in my skills. thanks Proposed Milest Mer

£14 GBP på 0 dager
(6 Omtaler)
1.8
bahaa63

A proposal has not yet been provided

£13 GBP på 1 dag
(2 Omtaler)
1.5
MizanurWorker

I'm ready for your project give me massage and let's start .....thank you Relevant Skills and Experience I have a good experience Proposed Milestones £13 GBP - 1 I understand

£13 GBP på 1 dag
(2 Omtaler)
1.0
glennwilkins

sir pm me i will finish this asap ... Relevant Skills and Experience excel/script Proposed Milestones £15 GBP - sir pm me i will finish this asap ... sir pm me i will finish this asap ...

£15 GBP på 0 dager
(1 anmeldelse)
0.9
waheeduet

I can work on excel for your desired formulas. I have done such project for myself. See my portfolio. Relevant Skills and Experience I am an engineer and expert in excel and its formulas. Proposed Milestones £13 GBP Mer

£13 GBP på 2 dager
(2 Omtaler)
0.8
Chinchan94

15 only for 1 day to finish the job Relevant Skills and Experience Exoert in EXCEL and WORD. Been doing formulation doing dashboard for my project at school so you have my assurance. Proposed Milestones £18 GBP - 1 d Mer

£18 GBP på 1 dag
(0 Omtaler)
0.0
apanchbhaiya

i will provide best work in average rate with skillful executive on given time period. Relevant Skills and Experience I have 5 years of experience in my last company Proposed Milestones £15 GBP - i'll complete the w Mer

£15 GBP på 1 dag
(0 Omtaler)
0.0
SSSAlam

Sir, give me chance to help you. Relevant Skills and Experience Excel, Word Proposed Milestones £18 GBP - Table

£18 GBP på 1 dag
(0 Omtaler)
0.0
joshct82

http://www.freelancer.com/u/joshct82 Competenze ed esperienze rilevanti http://www.freelancer.com/u/joshct82 Pietre Miliari proposte £18 GBP - Guaranteed work

£18 GBP på 10 dager
(1 anmeldelse)
0.1
jyotigupta55

A proposal has not yet been provided

£21 GBP på 1 dag
(0 Omtaler)
0.0
madylsabuclalao

I can complete your project within your budget Relevant Skills and Experience most currently , i am an accounting officer for a year and to date. im more knowledgeable in terms of excel Proposed Milestones £9 GBP - f Mer

£18 GBP på 3 dager
(0 Omtaler)
0.0
younusms

A proposal has not yet been provided

£13 GBP på 1 dag
(0 Omtaler)
0.0