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.
7 freelancers are bidding on average $24 for this job
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