Find Jobs
Hire Freelancers

Create excel formula

$10-30 CAD

キャンセル
投稿日: 約8年前

$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年前

お金を稼ぎたいですか?

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
お支払い方法確認済み
メンバー登録日:7月 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)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。