+ Reply to Thread
Results 1 to 4 of 4

Calculating how many outliers in a sheet based on name occurrence and overdue date

  1. #1
    Registered User
    Join Date
    11-01-2018
    Location
    London, England
    MS-Off Ver
    16
    Posts
    14

    Calculating how many outliers in a sheet based on name occurrence and overdue date

    I have a spreadsheet which calculates the dates when a project starts and ends, with the name of the person completing the project

    Columns - A: Job title, B: Name, C:Start date, D: Due date, E: Date of actual completion, F: Days overdue

    The point is to find out which people finish which projects late and how often this occurs. The problem is that the names often occur multiple times in the sheet, not in order, and new names are always being added to the sheet.

    Is there any way I can include a formula in column H which calculates how often someone completed a project late?

    E.g:
    Late projects
    H
    (Name) 4
    (Name) 0
    (Name) 7

    Thank you for your help in advance
    Last edited by ConstructT; 11-05-2018 at 06:58 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,108

    Re: Calculating how many outliers in a sheet based on name occurrence and overdue date

    Maybe use COUNTIFS?

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    11-01-2018
    Location
    London, England
    MS-Off Ver
    16
    Posts
    14

    Re: Calculating how many outliers in a sheet based on name occurrence and overdue date

    This worked for me, thanks very much!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,108

    Re: Calculating how many outliers in a sheet based on name occurrence and overdue date

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Flagging Overdue date based on two fields
    By tomb242 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-19-2015, 12:11 PM
  2. [SOLVED] Counting the number of days overdue based on date and time
    By Barking_Mad in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-08-2014, 10:57 AM
  3. Conditional format entire row based on overdue date range
    By jtrocki001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-31-2013, 11:32 AM
  4. array formula for calculating outliers
    By ravinatanson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2013, 08:54 PM
  5. [SOLVED] Overdue vs Today Date based on Criteria Meet
    By pjlau in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-01-2012, 01:09 PM
  6. Count the Occurrence Based on a Date
    By ChrisRocks in forum Excel General
    Replies: 2
    Last Post: 08-16-2011, 11:54 AM

Tags for this Thread

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