vba

Geschlossen

Beschreibung

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.

Fähigkeiten: Visual Basic

Mehr sehen: 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

Projekt-ID: #11808015

Vergeben an:

schoudhary1553

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 Mehr

$15 USD in 1 Tag
(9 Bewertungen)
3.8

7 Freelancer bietetn im Durchschnitt $24 für diesen Job an

$15 USD in 0 Tagen
(111 Bewertungen)
5.7
rengrish

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 Tag
(30 Bewertungen)
4.9
elqueabandona

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 Mehr

$25 USD in 0 Tagen
(24 Bewertungen)
5.0
prameswara

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 Mehr

$30 USD in 0 Tagen
(26 Bewertungen)
4.7
beltran0404

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 Tagen
(5 Bewertungen)
2.4
satishtl

- 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 Mehr

$30 USD in 1 Tag
(2 Bewertungen)
1.8
$55 USD in 1 Tag
(0 Bewertungen)
0.0