Find Jobs
Hire Freelancers

vba

$10-30 USD

Completed
Posted over 7 years ago

$10-30 USD

Paid on delivery
Simple excel macro: I have a list of start/end dates (two columns) for processes. Trying to count parallel runs: when a process starts how many processes are still running. For each row, in column C, place the number of current process running.(start date of current row <= end date of previous dates) If B cell is empty, only consider A cell which always has data. Assume rows are sorted by column A ascending. When start date of one row and and end date or a previous row are equal - that should be counted as a parallel run. See attached example for required output.
Project ID: 11808015

About the project

7 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$15 USD in 1 day
5.0 (9 reviews)
3.8
3.8
7 freelancers are bidding on average $24 USD for this job
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$25 USD in 0 day
4.9 (24 reviews)
5.0
5.0
User Avatar
Hi I can complete the macro within 30 mins. Please ping back. I have 10+ years of experience in Excel & VBA. Thank You Regards, Rishi R
$25 USD in 1 day
4.9 (30 reviews)
4.9
4.9
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel via VBA :) please give me a chance for doing your job and im able to start doing your project right now Sir Thank You Sincerely Prameswara
$30 USD in 0 day
5.0 (26 reviews)
4.7
4.7
User Avatar
Hello It will be my pleasure to assist you in this project. Please contact me by chat and then we could discuss better your project. Best regards, Luis Romero
$25 USD in 2 days
4.7 (5 reviews)
2.4
2.4
User Avatar
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Please review my portfolio on recent projects completed. - Have done Heating design based on current/voltage restrictions for each mat having multiple models, exam results grading by finding keywords, Canadian Province tax calculations based on province parameters, , merger of rows and columns of data based on key values My Skills: - I have good skills in Excel automation and used extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Outlook automation - Performing different actions other that using the existing rules, updating calendars based on logic. - MS Access - Expert in designing table, user input forms and also reporting from data. - Excel to MS access data porting and conversion and designing new system for use.
$30 USD in 1 day
5.0 (2 reviews)
1.8
1.8

About the client

Flag of UNITED STATES
Palo Alto, United States
5.0
1
Payment method verified
Member since Oct 17, 2016

Client Verification

Other jobs from this client

Design me a Product
$5000-10000 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.