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.

Habilidades: Visual Basic

Ver más: 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

Información del empleador:
( 1 comentario ) Palo Alto, United States

Nº del proyecto: #11808015

Adjudicado a:


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 Más

$15 USD en 1 día
(9 comentarios)

7 freelancers están ofertando el promedio de $24 para este trabajo

$15 USD en 0 días
(111 comentarios)

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 Más

$25 USD en 0 días
(24 comentarios)

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 en 1 día
(30 comentarios)

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 Más

$30 USD en 0 días
(26 comentarios)

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 en 2 días
(5 comentarios)

- 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 Más

$30 USD en 1 día
(2 comentarios)
$55 USD en 1 día
(0 comentarios)