This project was successfully completed by schoudhary1553 for $15 USD in a day.Get free quotes for a project like this
Project Budget$10 - $30 USD
Completed In1 day
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.
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online