Closed Thread
Results 1 to 18 of 18

Planned vs Actual Formula

Hybrid View

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    65

    Re: Planned vs Actual Formula

    Apologies I am not really aware of that features.

    Anyway, I already clicked the star icon to commend benishiryo's helped

    Before I mark this thread close, I would like to seek assistance in creating a single formula for my summary tab applicable to all months. In my sample, I want to show the performance of Bruce Wayne in every project he worked for June and July so that we will know if he was properly utilised or not. Would that be possible?

    Thank you again in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: Planned vs Actual Formula

    Hi,

    Find the updated sheet with formula in Summary sheet some changes are made in summary sheet.

    Punnam
    Attached Files Attached Files

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. A Schedule with Planned, Actual, Days +/- and Future Dates
    By jm90045 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-28-2013, 08:16 PM
  2. Traffic Light for Hours / Days actual vs planned
    By JPD in forum Excel General
    Replies: 4
    Last Post: 06-08-2011, 10:21 AM
  3. Planned vs. Actual Gantt
    By mycon73 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-22-2011, 01:10 AM
  4. Excel 2007 : Gathering Planned and Actual hours
    By Kburtt in forum Excel General
    Replies: 0
    Last Post: 02-28-2011, 10:42 PM
  5. [SOLVED] Conditional Formating planned VS actual date
    By rhatala@stny.rr.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-02-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1