Results 1 to 7 of 7

University schedule - check for duplicates and/or overlap

Threaded View

  1. #1
    Registered User
    Join Date
    09-02-2013
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2013
    Posts
    44

    University schedule - check for duplicates and/or overlap

    Hi,

    I have compiled schedules for severeal classes/groups and I would like to check for duplicates based on information from multiple cells. What I would like to check is if the "date" (column F), "time" (column I), and "Person" (column J) is the same or overlap. E.g. the person is scheduled for one group from 8-12 but also with another group from 10-14 (which obviously won't be ideal). I would also like to do the same control for date, time and room, so that two groups doesn't occupy the same room at the same time, or their classes overlap at the same room.

    With som help I was able to concatentate and match text strings, wich highlights the row if the above information is excatly the same, but not if the time overlaps.

    Any help would be appriciated! Feel free to add any helper columns, spilt the time column in start/end time or whatever is needed. I am pretty familiar with hos to build formulas, but I just can't figure out how to solve this. So if anyone is able to point me in the right direction or present any working formula I would be very happy. If VBA/macro is needed thats okey, I am familiar with basic VBA.
    Workbook attached.
    Attached Files Attached Files
    If I helped you out please add to my reputation.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Repeat or overlap check between two values
    By raghavakl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-29-2016, 02:43 AM
  2. Calculating schedule overlap
    By Karl_Ridener in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-04-2015, 12:18 AM
  3. [SOLVED] determine total overlap time when there are gaps in overlap (4 date ranges)
    By miriambender in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2014, 11:58 PM
  4. Replies: 0
    Last Post: 08-14-2013, 11:21 AM
  5. [SOLVED] Check for date and time overlap on a simple invoice
    By DJadwin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-19-2013, 10:11 PM
  6. Overlap check
    By zhshqzyc in forum Excel General
    Replies: 4
    Last Post: 03-22-2011, 10:41 AM
  7. Macro to check for blank cell entry, copy previous value, and check for duplicates
    By xPunxNotDeadx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2009, 06:33 PM

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