Excel VBA, All possible combinations given certain criteria -- 3

I need help to create an Excel VBA script that produces an amount of possible combinations with certain criteria regarding salaries and points.

I will provide a list in excel that will include 3 columns: name, salary, and points. This script should generate from 1 to 150 outcomes while picking 6 names but staying between $37,000 and $50,000 total salary. The outcomes need to sort by highest possible points first.

If this project is successful, there will be other similar projects for you to bid on.


The total salary for each 6 name combination cannot exceed $50,000 and go no lower than $37,000.

A name cannot be used more than once in the same output.

I would like the ability to select how many outputs to generate, from 1 to 150.

I will provide the list to the winning bidder. I want this to be something that I can easily run on my own as I add new names and salaries. This needs to be finished by Thursday, Feb 23 or Friday Feb 24 2017 at the latest.

Taidot: Excel

Näytä lisää: all possible combinations given a constraint, vba read data excel project, vba picture size excel, vba word powerpoint excel thumbnail image, vba populate msproject excel, vba provider access excel, add vba creator microsoft excel, excel project vba import, vba front end excel spreadsheet, vba export contacts excel, vba project data excel, vba create xml excel, access vba open format excel spreadsheet, vba excel project beginning, vba links website excel, update vba excel project, vba write xml excel, vba word output excel file, vba access similar excel, vba split separate excel

Tietoa työnantajasta:
( 1 arvostelu ) Chicago, United States

Projektin tunnus: #13169340

Myönnetty käyttäjälle:


Hi, I am good at Excel combination algorithm and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your proje Lisää

$100 USD 2 päivässä
(355 Arvostelua)

38 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello Sir, Thank you for this opportunity. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Lisää

$200 USD 3 päivässä
(399 arvostelua)
$180 USD 2 päivässä
(246 arvostelua)

Hi, I am an Excel VBA expert and can handle the project requirements. Also, I have been involved in some similar projects earlier. Shall try to make the solution user friendly. Let me know. Regards, Arul

$150 USD 3 päivässä
(159 arvostelua)

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Plea Lisää

$150 USD 3 päivässä
(103 arvostelua)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Lisää

$155 USD 3 päivässä
(109 arvostelua)

Hi there. My name is Daniel and I would be glad to help you out with this project. I can create a VBA macro able to simulate all possible combinatios according to the criteria. I can guarantee an excellent job and deli Lisää

$199 USD 3 päivässä
(64 arvostelua)

I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already do ne 100 works on Freelancer where majo Lisää

$200 USD 3 päivässä
(74 arvostelua)

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macr Lisää

$88 USD 2 päivässä
(59 arvostelua)

Goal Seeking project due Feb 23. Greetings from Easton PA, USA.. {smile} Highly experienced (25+ years) MsEXCEL Business System, Programming, and Database expert with Guru / Mentor level technical credentials at Lisää

$114 USD 3 päivässä
(27 arvostelua)
$100 USD 1 päivässä
(81 arvostelua)

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Lisää

$99 USD 2 päivässä
(39 arvostelua)

hi sir i had very high and fresh quality list may be u interested of it [url removed, login to view] 240,000 email list [url removed, login to view] [url removed, login to view] 200,000 email list htt Lisää

$150 USD 3 päivässä
(21 arvostelua)

I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Thank you..

$50 USD 1 päivässä
(14 arvostelua)

I create all kind of Excel Applications by VBA, formulas, pivot tables, including screen layout's, reports, charts, and dynamic dashboards. I am a specialist in financial reports, budget, costing reports, inventories, Lisää

$200 USD 3 päivässä
(13 arvostelua)

Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I can complete your job by Thursday 23rd Feb. I have excellent knowledge and experience of Manipulating Data from Multiple S Lisää

$120 USD 2 päivässä
(33 arvostelua)

PLease provide the spreadsheet as it is not clear what "points" is. IF I take the 2 constraints of 50,000 and 37000 only, then it is possible to generate infinite number of salaries.

$100 USD 3 päivässä
(46 arvostelua)

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Mana Lisää

$30 USD 1 päivässä
(17 arvostelua)
$50 USD 1 päivässä
(12 arvostelua)

Hi, I am an excel expert specializing in VBA macro. I can finish the job in a day. Thanks and best regards, John

$111 USD 1 päivässä
(7 arvostelua)

Hi I am an Engineering undergraduate with exceptional skills in mathematics. I am well experience in using excel for maths related calculations and data analysis. I can do this for you. Please message to discuss furth Lisää

$45 USD 3 päivässä
(3 arvostelua)