+ Reply to Thread
Results 1 to 2 of 2

advanced formula for linking values in two sheets (differ.) under conditions

  1. #1
    Registered User
    Join Date
    08-10-2011
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    1

    advanced formula for linking values in two sheets (differ.) under conditions

    Hi! I attach 3 sheets with sample data and below I describe the problem I have - I mean the idea of what I want achieve, but don't know how to do it

    The aim is to link the amount of days that someone is on holiday in particular month with the planned days in which he should work in the particular project running by my company.

    1. the 'planning base' sheet descibes the percentage of involvement in the project
    2. 'planning days' sheet describes involvement in days (working days*involvement)
    3. the column named 8v, 9v, 10v, etc in the 'planning days' sheet should present the DIFFERENCE between column 8, 9, 10, etc and the planned vacations from sheet 'vacations' in the particular month.
    4. Take note that the same person is involved in more than one project.
    5. Example: in cell M3 I want to see: "11" - '10' (days of his holidays in August).

    Could you please help me solve this challenge?

    Thank you and regards,
    Rita
    Attached Files Attached Files
    Last edited by the_draker; 08-10-2011 at 07:06 AM. Reason: bad title

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Reques for help: advanced formul needed

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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