Find Jobs
Hire Freelancers

excel-macro for combinations

€8-30 EUR

In Progress
Posted about 6 years ago

€8-30 EUR

Paid on delivery
Hello I'm looking for someone who is capable to write a macro in excel. In my paradigm I use a total of 20 characteristics. Each time, 5 characteristics are drawn from these 20 to form one element. The macro should display all combinations that are possible when 5 of these 20 characteristics are used (all possible elements consisting of 5 charactristics). It is important that the order is irrelevant (123 is the same as 132) and there is no repetition (122 is not possible). As an Example, 1 2 3 would give the following combinations of 2: 12 13 23 I need to get the file until saturday 31.03.2018. Best regards, Fabienne
Project ID: 16574385

About the project

12 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
12 freelancers are bidding on average €23 EUR for this job
User Avatar
Dear Employer, I completely understand you need to make different permutations in a given set of 20 numbers. I will do this job. I am good with maths. In 20 numbers if you want to make a set of 5 it will be 1,860,480 numbers. I will do this. Please give me a chance. Thanks and Regards, Ash
€29 EUR in 1 day
5.0 (246 reviews)
8.1
8.1
User Avatar
I am proficient with excel macro/VBA, I can write the macro to form element based on characteristics selected, I will be available during the development to keep you updated or address any questions you may have, await for your precious reply to discuss the detail to start.
€20 EUR in 1 day
5.0 (129 reviews)
6.6
6.6
User Avatar
Hi, Reading your project description about writing an Excel Macros makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Rather than just show you past similar projects, I want to exceed your expectation by completing a part of your job as a FREE sample before you award the project. If you are satisfied with the result, you can go ahead and award the project. Please let my reviews do the talking. Do you want me to start working on the sample right away?
€23 EUR in 1 day
4.9 (63 reviews)
6.9
6.9
User Avatar
Hello, I would like to work on your project. I have great experience using excel macros / vba, data formatting and data manipulation in excel. I intend to create 1 macro which will take from 1 worksheet 20 characteristics and will create in the same sheet or in other worksheet all combinations of 5 characteristics from 20 within 5 columns and as many rows needed. (15504 rows). Regards.
€25 EUR in 0 day
5.0 (161 reviews)
6.8
6.8
User Avatar
- Based no the 20 characteristics, pull out the combinations of 5. - Have done similar combinations for one of the projects recently which I should showcase. - Character matching, scoring based on pattern matching these are some of the projects done using pattern matching(snapshot can be sent on the pattern matching done) My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects.
€24 EUR in 1 day
4.6 (51 reviews)
6.1
6.1
User Avatar
Hello, I have read the instructions and I'm totally happy to create the macro for you. I can provide the file tomorrow. If you are interested please open a chat with me. Kind regards, Sorin
€29 EUR in 1 day
5.0 (61 reviews)
5.5
5.5
User Avatar
Available Immediately | VBA Expert | MBA | Assured accuracy and minimum turnaround time | MS Excel Champion
€23 EUR in 1 day
5.0 (10 reviews)
4.6
4.6
User Avatar
Hi, this is easy macro task.. I can make it in 2 hours max!.. if you award me this project, consider it done.. :)
€20 EUR in 1 day
5.0 (9 reviews)
4.0
4.0
User Avatar
Please let me know how you want to set up the characteristics. Do you want to read them from a file, enter them by hand, or something else. All can be done, but let's select the best approach for you. David PS: I have left time for deciding the above and any testing you might need to do before acceptance.
€14 EUR in 2 days
5.0 (20 reviews)
4.1
4.1
User Avatar
Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas and Macros using VB, the most important thing is that I can do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.
€20 EUR in 3 days
5.0 (15 reviews)
3.8
3.8
User Avatar
hey. i would make professionaly excel-macro for combinations. On the other after this we will design it also!
€14 EUR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWITZERLAND
Zürich, Switzerland
0.0
0
Payment method verified
Member since Mar 27, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.