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.
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 knowledge about Excel Formula. Might need to chat with you to really understand what's your request.
£18 GBP om 1 dag
5,0 (2 omtaler)
1,0
1,0
27 frilansere byr i gjennomsnitt £18 GBP for denne jobben
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 now. Lets get it done quickly.
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 formula done
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
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
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.
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
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
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 Milestones
£14 GBP - formula
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
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 ...
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 - Pay on work completion
Please contact me so that I may help you
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 day - Job Finished
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 work as per client requirement
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 - first part
£9 GBP - 2nd part