Results 1 to 3 of 3

Find number of overlapping days per person

Threaded View

  1. #1
    Registered User
    Join Date
    03-18-2016
    Location
    London, UK
    MS-Off Ver
    2013
    Posts
    1

    Find number of overlapping days per person

    Hello

    I have a data set which contains:

    Names on Column A
    Start Date on Column B
    End Date on Column C
    Team Name on Column D
    Role on Column E

    There are multiple entries for the same names on Column A as some players are part of different teams. I need to find how many days a name on Column A was part of Team A and Team B at the same time.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate number of days required by each person at any time on a date
    By Robbie8 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-21-2016, 03:55 PM
  2. [SOLVED] Excel Formula/Function to find total number of non-overlapping months
    By akynyemi in forum Excel General
    Replies: 6
    Last Post: 09-07-2015, 06:15 PM
  3. [SOLVED] How to find Sum of # of days w/o counting overlapping days twice
    By lanksout in forum Excel General
    Replies: 18
    Last Post: 08-11-2015, 02:15 AM
  4. Count number of overlapping days in multiple date ranges
    By tarsonis in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-08-2015, 03:22 PM
  5. [SOLVED] Find number of occurrences for particular person
    By Harry Basra in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-18-2013, 09:14 AM
  6. Replies: 0
    Last Post: 07-30-2012, 04:51 PM
  7. Replies: 8
    Last Post: 04-30-2012, 11:26 AM

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