Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

Jay has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Excel

I need to calculate the percentage of times a report is run over the scheduled time using two criteria. the name of the report and the month its run in.

I have a list or reports, list of months and list of completion times along with the scheduled completion time.

RE: excel

Hi Jay

Thanks for your post which a colleague has passed for my attention. A solution could present itself in 10 minutes or take several hours, what we would need to so is:

1) Have you send us your working files
2) Bullet point all the items you are trying to achieve

We will then review and if a solution is available we will let you know the scope of work to complete:

1) Duration (hours/days)
2) Breakdown of work
3) Schedule of work

Only upon your agreement will work commence. If you wish to discuss this further please get in touch or if it can wait till your attendance on our Excel VBA course in December, depending on any spare time your trainer has, they may be able to give you a few pointers.

Kind regards

Jacob

Fri 5 Nov 2010: Automatically marked as resolved.

Excel tip:

Shortcut fill a cell with contents from adjacent cells

Use Control + D to fill a cell with the data from an adjacent cell. This speeds up data entry and is a cool tip to share!


View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.