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.

Skills: Visual Basic

See more: vba connection as400, access 2007 report pdf vba, excel vba add installation, csv txt vba, macro install vba, paste access vba, counter vba access, excel vba error, ftp download vba, vba optimization, project vba date format, vba creare xml, vba email access, replace text textfile vba, excel vba xml

About the Employer:
( 1 review ) Palo Alto, United States

Project ID: #11808015

Awarded to:


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 ex More

$15 USD in 1 day
(9 Reviews)

7 freelancers are bidding on average $24 for this job

$15 USD in 0 days
(111 Reviews)

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 rega More

$25 USD in 0 days
(24 Reviews)

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
(30 Reviews)

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 Pram More

$30 USD in 0 days
(26 Reviews)

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
(5 Reviews)

- 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 restrictio More

$30 USD in 1 day
(2 Reviews)
$55 USD in 1 day
(0 Reviews)