Find Jobs
Hire Freelancers

Create excel formula

$10-30 CAD

Dibatalkan
Dibuat sekitar 8 tahun yang lalu

$10-30 CAD

Dibayar ketika dikirim
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 Proyek: 9991919

Tentang proyek

45 proposal
Proyek remot
Aktif 8 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
45 freelancer menawar dengan rata-rata $31 CAD untuk pekerjaan ini
Avatar Pengguna
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 dalam 0 hari
5,0 (809 ulasan)
8,8
8,8
Avatar Pengguna
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 dalam 1 hari
4,9 (464 ulasan)
8,0
8,0
Avatar Pengguna
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 dalam 1 hari
4,9 (331 ulasan)
8,0
8,0
Avatar Pengguna
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 dalam 0 hari
4,9 (393 ulasan)
7,5
7,5
Avatar Pengguna
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 dalam 1 hari
5,0 (54 ulasan)
6,1
6,1
Avatar Pengguna
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 dalam 1 hari
4,9 (77 ulasan)
6,1
6,1
Avatar Pengguna
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 dalam 1 hari
4,9 (74 ulasan)
6,0
6,0
Avatar Pengguna
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 dalam 1 hari
5,0 (42 ulasan)
6,0
6,0
Avatar Pengguna
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 dalam 1 hari
4,8 (81 ulasan)
6,0
6,0
Avatar Pengguna
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 dalam 0 hari
4,7 (75 ulasan)
5,5
5,5
Avatar Pengguna
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 dalam 1 hari
4,6 (43 ulasan)
5,6
5,6
Avatar Pengguna
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 dalam 1 hari
4,8 (50 ulasan)
5,1
5,1
Avatar Pengguna
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 dalam 1 hari
4,5 (50 ulasan)
5,0
5,0
Avatar Pengguna
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 dalam 1 hari
5,0 (8 ulasan)
4,2
4,2
Avatar Pengguna
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 dalam 1 hari
4,9 (27 ulasan)
4,3
4,3
Avatar Pengguna
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 dalam 1 hari
4,9 (3 ulasan)
3,7
3,7
Avatar Pengguna
Hi, A macro can do that!!! Please contact for further details of ypur project. Thanks!...........................................................................
$25 CAD dalam 1 hari
4,6 (12 ulasan)
4,1
4,1
Avatar Pengguna
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 dalam 1 hari
5,0 (5 ulasan)
3,4
3,4
Avatar Pengguna
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 dalam 2 hari
5,0 (1 ulasan)
3,4
3,4
Avatar Pengguna
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 dalam 1 hari
4,7 (5 ulasan)
2,5
2,5

Tentang klien

Bendera CANADA
Montreal, Canada
5,0
27
Memverifikasi Metode pembayaran
Anggota sejak Jul 8, 2009

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.