Завершено

Excel Workbook with advanced formula table

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.

Квалификация: Обработка данных, Excel, Архитектура ПО, Visual Basic

Показать больше transfer data excel multiple sheet access table, excel workbook software, convert excel workbook windows application, vlookup in excel, excel create dynamic list from table, advanced excel formulas with examples in excel sheet pdf, excel table formula, advanced excel 2016 pdf, =table() excel, excel tables examples, excel formulas, convert excel workbook, convert excel workbook stand alone application, convert excel workbook standalone, data excel workbook master workbook using vba, convert excel workbook visual basic, upload excel workbook turbolister, vb script sql server table excel workbook, excel formula table, i have 500 pdf to be transcribed in excel in 10 different fields need it quick!

О работодателе:
( 8 отзыв(-а, -ов) ) Atlantic beach, United States

ID проекта: #20013602

Поручен:

nvchien94

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 t Больше

$20 USD за 1 день
(93 отзывов(-а))
5.3

37 фрилансеров(-а) в среднем готовы выполнить эту работу за $25

schoudhary1553

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. Больше

$50 USD за 1 день
(346 отзывов(-а))
7.9
prameswara

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 за 1 день
(356 отзывов(-а))
7.1
dgled

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, sc Больше

$50 USD за 1 день
(78 отзывов(-а))
7.0
best4best

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 n Больше

$25 USD за 1 день
(149 отзывов(-а))
6.4
valor312

VERY EASY for ME Hi, Nice to meet you. Please see product I made recently using VBA https://www.freelancer.com/projects/software-architecture/Excel-xml-file-online-wizard/?w=f https://www.freelancer.com/projects/ Больше

$25 USD за 1 день
(81 отзывов(-а))
6.0
lightingdavid

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 a Больше

$30 USD за 1 день
(112 отзывов(-а))
6.1
rengrish

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 i Больше

$30 USD за 1 день
(150 отзывов(-а))
5.9
sourabhg98

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 r Больше

$19 USD за 1 день
(104 отзывов(-а))
5.5
vsprybhanu

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, Больше

$30 USD за 1 день
(73 отзывов(-а))
5.5
citijayamala

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 mark Больше

$80 USD за 2 дней(-я)
(67 отзывов(-а))
5.6
alekhine1962

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 t Больше

$25 USD за 1 день
(24 отзывов(-а))
4.7
standarditech

Hi, I have taken a deep look on this project, and I am sure that we can work together. I have experienced in these kind of task. I will complete this task with your timeline and [login to view URL] give me a chance to serve Больше

$15 USD за 1 день
(78 отзывов(-а))
4.9
AkilaArun

Hi, I am interested in working on this project. Saw the attachment. The output should contain all possible combination of set of 5 numbers between 1 and 35 so that the sum of each set is equal to the specified input n Больше

$30 USD за 1 день
(38 отзывов(-а))
5.0
xinglong717

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 за 7 дней(-я)
(31 отзывов(-а))
5.1
sergeyprince

Hello. I have got 8 years of rich experiences in VBA. I can do VBA programming as fast as you want .I am Data Processing , Excel VBA Expert who knows the value of time, very hard working and always delivers the work o Больше

$30 USD за 1 день
(7 отзывов(-а))
2.6
ducdac

Dear sir. I am an algorithm expert. I've carefully read your description. Your project is very interesting. I am sure I can help you with your project. Hope to meet and have a talk. Thanks for your attention.

$15 USD за 1 день
(4 отзывов(-а))
2.1
writingapp

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 за 1 день
(5 отзывов(-а))
2.2
maheshrai640

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 th Больше

$15 USD за 1 день
(2 отзывов(-а))
1.6
tusharvv76

I have FULL CONFIDENCE of completing this project using Excel VBA macro. Doing this task only using formulas is (I think) not possible as there are various inter- and intra-dependencies between the cells as well as row Больше

$15 USD за 1 день
(3 отзывов(-а))
1.4
AnowarRatul

$ 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 yo Больше

$10 USD за 1 день
(2 отзывов(-а))
0.6