Create excel formula


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:


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!

Квалификация: Excel

Показать больше create auction joomla, create joomla template, create gadget, create automated booking system, create flash flower, create isapi filters, create web page footer

О работодателе:
( 25 отзыв(-а, -ов) ) Montreal, Canada

ID проекта: #9991919

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


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

$30 CAD за 0 дней(-я)
(487 отзывов(-а))

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

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

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

$25 CAD за 1 день
(110 отзывов(-а))

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

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

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

$24 CAD за 1 день
(70 отзывов(-а))

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

$29 CAD за 1 день
(40 отзывов(-а))

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

$25 CAD за 1 день
(28 отзывов(-а))

hi sir.i have a list ---------------------- best email list clean very low bounce rate Email was extracted from their own official web site LIST: 1 000,000 USA EMAIL - all have email PRICE: $250 sample: Больше

$100 CAD за 1 день
(21 отзывов(-а))

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

$35 CAD за 1 день
(49 отзывов(-а))

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

$35 CAD за 1 день
(22 отзывов(-а))
$15 CAD за 1 день
(20 отзывов(-а))

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

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

$30 CAD за 0 дней(-я)
(24 отзывов(-а))

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

$20 CAD за 1 день
(31 отзывов(-а))

Analytical and performance driven financial professional with diversified experience in financial analysis, projection and investment. Expertise in investment strategies, asset valuation and portfolio management combin Больше

$35 CAD за 1 день
(8 отзывов(-а))

Hi, A macro can do that!!! Please contact for further details of ypur project. Thanks!...........................................................................

$25 CAD за 1 день
(12 отзывов(-а))

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

$30 CAD за 1 день
(5 отзывов(-а))

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

Hello, sir. I am very interested from your project. I'm TOP 6TH freelancer as you can see my profile ( I have enough skills for your project. Kind Regards

$206 CAD за 2 дней(-я)
(1 отзыв)