Find Jobs
Hire Freelancers

Excel Workbook with advanced formula table

$10-30 USD

Completed
Posted almost 5 years ago

$10-30 USD

Paid on delivery
I need an excel worksheet created that will produce the following data - a list of numerical combinations using 5 numbers, with the numbers being any combination equal to or between 1-35 (numbers do not repeat in a single combination) and the total for these combinations equal "X" "x" = a+b+c+d+e, f+h+h+e+y, etc... Functionality: In column A3 i would like to enter the number 98 - when this number is entered into cell A3 a list of combinations that have 5 numbers should be shown below. each number in the 5 number combination needs to be in its own cell. please review the attachment for visual example. Rule : only use numbers between 1-35 when creating combinations Rule: numbers do not repeat in a single combination.
Project ID: 20013602

About the project

32 proposals
Remote project
Active 5 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
Awarded to:
User Avatar
Hello there, I am an Excel expert and your function must need VBA code to do. Please contact me, I will create 1 script with the logic do to it for you. NO formula can do this task, trust me. Thank you. Project will take 1 hour to complete.
$20 USD in 1 day
5.0 (196 reviews)
6.3
6.3
32 freelancers are bidding on average $26 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553?w=f I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$50 USD in 1 day
4.9 (393 reviews)
8.1
8.1
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can do help you build formula in your table Sir please ping me now and im able to start working right now Thank you Galih
$30 USD in 1 day
4.9 (390 reviews)
7.3
7.3
User Avatar
Hi, I am an expert and guru in Financial, Math and Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script for charts). Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I develop modules which incorporate complex components of business in a simplified and logical manner. I am sure that my combined knowledge, skills and creativity will lead to exceptional results that will exceed your expectations.
$50 USD in 1 day
4.9 (90 reviews)
7.1
7.1
User Avatar
Hi, I am an Excel expert. I have a question: Would a combination of (a+b+c+d+e) be considered same as (e+d+c+b+a) or not? I mean if sequence of numbers is changed, then should that combination be listed as unique or not. Please take a look at my portfolio for Excel projects. Regards MS
$25 USD in 1 day
5.0 (164 reviews)
6.4
6.4
User Avatar
Hello. I 'm expert in "Visual Basic, Data Processing, Excel, Software Architecture" and I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description carefully and i can do it. I 'll do my best till you satisfy if you want me. Contact me please. Thank you. Yang L.
$30 USD in 1 day
4.8 (115 reviews)
6.1
6.1
User Avatar
Hi I have went through the file and requirement . Need to generate unique combination of 5 numbers to produce the sum entered. I can complete the job within 30 mins. Please ping back. I have 10+ years of experience in Excel /VBA. I propose a macro to do this. Thank You Regards Rishi R
$30 USD in 1 day
4.9 (158 reviews)
6.0
6.0
User Avatar
Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at www.excelforum.com. I would like to provide my services for this project. This project requires a bit of mathematical knowledge and shortcuts and an efficient code. You dont just need any code but a code that is fast enough to handle large amounts of data because the number of combinations would increase exponentially. I am aware of the proper and efficient way to generate the combinations such that they match the given sum without using brute force. I will also use array based programing for faster processing. I can assure you the Excel VBA script I will provide will be the fastest and a cent percent accurate. Can start now and deliver within an hour. No need to install any third party add-ins or softwares, just a simple clean excel file. I look forward to a positive and prompt response from your side. Regards Sourabh
$19 USD in 1 day
5.0 (143 reviews)
6.0
6.0
User Avatar
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$80 USD in 2 days
4.7 (73 reviews)
5.7
5.7
User Avatar
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$30 USD in 1 day
4.8 (92 reviews)
5.7
5.7
User Avatar
Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
$30 USD in 1 day
4.9 (42 reviews)
5.3
5.3
User Avatar
In an hour. I can complete your project. I have many experiences. I can complete your project successfully. I'm software engineer and algorithm expert. I'm fullstack website developer and database manager. Thanks.
$50 USD in 7 days
4.9 (36 reviews)
5.3
5.3
User Avatar
$ 10 ONLY !!!!! Sir, I understand your requirements very well and saw your attachment, this is quite basic to me. I have expertise in Excel Formula Generation, Excel VBA, Pivot Table, Chart, Graph etc. I can assure you I will deliver your project within very short time and for VERY CHEAP rate. Please CONTACT me before closing the project, I will send you a draft project file to ensure my expertise. I have more than five years of real job experience of this kind of work. I will be very much grateful if I get the opportunity to work for you. Thanks, Anowar
$10 USD in 1 day
5.0 (100 reviews)
5.3
5.3
User Avatar
Dear Buyer, I program with VBA code since 1998. What you ask is simple and can be easily accomplished with a small VBA function in no more that one day. I would be glad to assist you in accomplishing this task. Many thanks in advance for considering my bid. With best regards, Solon ...
$25 USD in 1 day
4.9 (24 reviews)
4.7
4.7
User Avatar
Hello....... I can do it well ....and i also want to start it now.... Please give me a chance to work with you .....you will be really satisfied...I promise the accuracy of work will be definitely 100%...... Give me the one and only chance for your work.... You will get your delivered in given time.... Chat me to discuss the details so that i can start the work ASAP Thankyou
$15 USD in 1 day
5.0 (8 reviews)
3.1
3.1
User Avatar
Hi, i can provide this requirement's solution. I hope what you have given as 98 is an example. Is it an example? Do you need all the possibilities for 98? Please come in chat. Accordingly i can provide a generalised solution
$20 USD in 2 days
5.0 (5 reviews)
2.2
2.2
User Avatar
Hello, I am interested in your project, I have a huge experience in that field. I can get you free samples I am ready to deliver your order within 24 hours. Please contact me and let discuss for more detail. Everything you say will be weighed with care. Thanks and Regards.
$12 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Trust me, I am the best person for this kind of work. I will submit the work within the given period. If you give me the project, I am sure You will give me further projects too.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm new in freelancer, so my bid is low , give me a chance to prove myself and will help to you also
$20 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear sir this is my first project on freelance. Before I using freelance I write some data entry in excel I have experience this work 4 year . Please provide one chance for your help. Relevant Skills and Experience Dear sir this is my first project on freelance. Before I using freelance I write some data entry in excel I have experience this work 4 year . Please provide one chance for your help.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I need to get some more information about the job and I will be there at the end of the day and then I need to get
$10 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Atlantic beach, United States
5.0
9
Payment method verified
Member since Jan 13, 2016

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)
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.