Find Jobs
Hire Freelancers

Create excel formula

$10-30 CAD

Скасований
Опублікований about 8 years ago

$10-30 CAD

Оплачується при отриманні
Hello, I have a simple and quick task. I need a formula that will read an input from a table to output data as per the examples below and demonstrated in the attached pictures: Example1: In row 2, under info 1, there is an "a": that record has 2 days where a payment takes place, day 5 and 6. That should be converted to the output table and the output should be 2 records/rows since the payment happen on 2 separate days Example 2 The 4th record in input has 4 days of payment, the output should be 4 rows, 1 for each day. IMPORTANT: NO Macros allowed! Only formulas. Thank you!
ID проекту: 9991919

Про проект

45 пропозицій(-ї)
Дистанційний проект
Активність 8 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
45 фрілансерів(-и) готові виконати цю роботу у середньому за $31 CAD
Аватарка користувача
Hello Sir, 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 Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$30 CAD за 0 день
5,0 (809 відгуки(-ів))
8,8
8,8
Аватарка користувача
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$25 CAD за 1 день
4,9 (464 відгуки(-ів))
8,0
8,0
Аватарка користувача
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$25 CAD за 1 день
4,9 (331 відгуки(-ів))
8,0
8,0
Аватарка користувача
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel Sir :) please give me a chance for doing your job and im able to start doing your job right now ;) Thank You Sincerely Prameswara
$30 CAD за 0 день
4,9 (393 відгуки(-ів))
7,5
7,5
Аватарка користувача
I am a certified Microsoft Office Professional. Doing this without macros is tricky. I wanted to try this before I can assure you anything, So, I already started working out a solution for your problem. Am half way through, However, I need some clarifications. You can award me the project only after our discussion. Hope to hear from you soon.
$25 CAD за 1 день
5,0 (54 відгуки(-ів))
6,1
6,1
Аватарка користувача
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 65 projects, almost 55+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$24 CAD за 1 день
4,9 (77 відгуки(-ів))
6,1
6,1
Аватарка користувача
Now I can show you the samples. Pm me for sample. Hi Mr. Employer I can do this project in effective manner with 100 % accuracy report to fulfill your requirements. Pm me for more information and sample as well. **** I can finished with in an hour. **** Thank you for your opportunity to bid RoyalCalif
$20 CAD за 1 день
4,9 (74 відгуки(-ів))
6,0
6,0
Аватарка користувача
Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and portfolio. With over 8 years of cross-functional experience, and helping clients world wide with diversify team, I provide genuine and innovative solutions as per your circumstances and requirements. I am MBA-Finance, M.A-Economics, and Qualified Chartered Accountant. If you feel to discuss more before you award me the project, you can send me the message. Kind regards, Rakesh
$30 CAD за 1 день
5,0 (42 відгуки(-ів))
6,0
6,0
Аватарка користувача
I can do it using formulas only I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Build a reservation system - Build a complex shift allowance calendar and calculator You can see the reviews of the same in my profile
$35 CAD за 1 день
4,8 (81 відгуки(-ів))
6,0
6,0
Аватарка користувача
Hi, I have gone through your project details and would like to take an opportunity to work on it. I have worked on several Excel projects and able to deliver successfully, so I can help you on it. I have checked your examples and images you shared. I would like to tell you that output you require is not possible alone with Excel formulas, a small macro will need to be written for the same. Waiting for your response to talk further. Thanks.
$30 CAD за 0 день
4,7 (75 відгуки(-ів))
5,5
5,5
Аватарка користувача
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 and will deliver flawless work. I am very much able to work on this. ***I am ready to start Waiting for further discussion.. with thanks and regards
$29 CAD за 1 день
4,6 (43 відгуки(-ів))
5,6
5,6
Аватарка користувача
Hi there! I'm a web developer.I'm get bachelor IT certificate on 2013.I have 3+ year in web development.I provide services with enthusiasm, creativity, pay until you are satisfied with my quality services and reach your purposes. My Services: Website design and development. Responsive website. Excel fomulas - Dashboard design -VBA Programming. Data entry -product upload-CMS- Virtual Assistant. Html-Css-javascript. PHP-Wordpress-C# Unity. Software Testing. Hire me for: - Fast turnaround time - satisfy 100%.Lifetime support. - Working everyday. - realtime responding.
$35 CAD за 1 день
4,8 (50 відгуки(-ів))
5,1
5,1
Аватарка користувача
Appears an interesting problem. I should be able to solve it. You can pay me only if you are 100% satisfied. Meanwhile, I will work on it and notify you if I find a solution
$25 CAD за 1 день
4,5 (50 відгуки(-ів))
5,0
5,0
Аватарка користувача
Analytical and performance driven financial professional with diversified experience in financial analysis, projection and investment. Expertise in investment strategies, asset valuation and portfolio management combined with business development. Tapped into market and business trend as well as market analysis. CFA level I candidate with an MBA and MS in Financial Engineering degree Have experience with following work Business Plans
$35 CAD за 1 день
5,0 (8 відгуки(-ів))
4,2
4,2
Аватарка користувача
Hello, I have take a look you attachment pictures and understand the needed. as requested I will only use formulas for project. appreciate if we can talk thru pm before project awarded. thanks & Regards, gs_anggara
$25 CAD за 1 день
4,9 (27 відгуки(-ів))
4,3
4,3
Аватарка користувача
Hello, I can do the job in less time, and 100% accurate (using formulas) - I'm a Visual Basic programmer, I write programs in VB6 since 2007, in VB.Net since 2013. - Have long experience with MS-Excel (formulas & VBA macros). - Have long experience with winsock applications, FTP connections, math stuff & calculations, applications that works with files & folders, and creating mini-tools that automate tasks while working in background. - Experience with database based applications (MS-Access & SQL Server). - Accuracy and precision is one of my principles, also one of my best advantages. - Commitment to deliver tasks in time. I I'm looking forward to working with you, helping you to solve problems :) Please feel free to contact me to discuss any further details.
$29 CAD за 1 день
4,9 (3 відгуки(-ів))
3,7
3,7
Аватарка користувача
Hi, A macro can do that!!! Please contact for further details of ypur project. Thanks!...........................................................................
$25 CAD за 1 день
4,6 (12 відгуки(-ів))
4,1
4,1
Аватарка користувача
Hello. I can develop the formulas needed to accomplish your task. I am an expert with excel and regularly develop spreadsheets for a variety of purposes, including design calculations, cost estimations, KPI dashboards, and more. I am an engineer so you can expect nothing less than detail oriented, meticulous, professional grade work, and an impeccable final product. Please send me a message to discuss additional details and I can confirm my commitment.
$30 CAD за 1 день
5,0 (5 відгуки(-ів))
3,4
3,4
Аватарка користувача
Hello, sir. I am very interested from your project. I'm TOP 6TH freelancer as you can see my profile (https://www.freelancer.com/u/kchg.html). I have enough skills for your project. Kind Regards
$206 CAD за 2 дні(-в)
5,0 (1 відгук)
3,4
3,4
Аватарка користувача
As an expert of advanced excel and have 6 years of corporate experience in using complex formulas, so I can complete this task with accuracy.
$10 CAD за 1 день
4,7 (5 відгуки(-ів))
2,5
2,5

Про клієнта

Прапор CANADA
Montreal, Canada
5,0
27
Спосіб оплати верифіковано
На сайті з лип. 8, 2009

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.