+ Reply to Thread
Results 1 to 4 of 4

Compare schedules and generate a list of missing coverage.

  1. #1
    Registered User
    Join Date
    01-05-2014
    Location
    Portland, Maine
    MS-Off Ver
    Office 2007, 2010, 2013
    Posts
    10

    Compare schedules and generate a list of missing coverage.

    I'm trying to compare an actual schedule with a template schedule and generate a list of time that have not been covered.

    It has to be fast as I intend to have it recalculate as the sheet is updated.
    Attached Images Attached Images
    Daniel Davis

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Compare schedules and generate a list of missing coverage.

    Submitting your workbook is much more helpful than a picture of your workbook.

  3. #3
    Registered User
    Join Date
    01-05-2014
    Location
    Portland, Maine
    MS-Off Ver
    Office 2007, 2010, 2013
    Posts
    10

    Re: Compare schedules and generate a list of missing coverage.

    Please see: http://www.excelforum.com/showthread.php?t=1057720

    My workbook is much more complex than the picture was designed to represent, and I was getting no traction on the original post, so I was trying to be simple.

    DNA Tech Solutions

  4. #4
    Registered User
    Join Date
    01-05-2014
    Location
    Portland, Maine
    MS-Off Ver
    Office 2007, 2010, 2013
    Posts
    10

    Re: Compare schedules and generate a list of missing coverage.

    I'm also at work and have no internet access to upload the simpler file. My phone won't let me do it. The original thread has the full file though

    DNA Tech Solutions

+ 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. [SOLVED] Compare two columns on separate sheet, if missing, insert missing data
    By lilvictorians in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-03-2019, 11:44 PM
  2. VBA to Generate Missing
    By mvinay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2014, 03:12 AM
  3. Compare two lists in excel and create new list with missing values
    By brian53199 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2013, 12:32 PM
  4. Compare two columns and produce a list of 'missing' items
    By woodsonline in forum Excel General
    Replies: 5
    Last Post: 08-05-2008, 04:39 AM
  5. [SOLVED] Compare worksheets and generate list of missing data?
    By Minuette in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-03-2005, 09:45 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