Results 1 to 5 of 5

Dynamic removal of duplicates

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2009
    Location
    Bristol, England
    MS-Off Ver
    Excel 2010
    Posts
    81

    Dynamic removal of duplicates

    I have a list of data in two columns. The data ralates to areas and times of cleaning shifts in a hospital environment. The first column is a list of data that indictaes the shifts that are vacant, for example when people are on holidy or are sick. The 2nd column shows the shifts that are subsequently filled by other staff. What I need is for a third column to sort this automatically to leave just the shifts that havent been filled

    Workbook attached

    Thoughts

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Creating a dynamic top 10 list and ignoring duplicates
    By justmill in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-23-2014, 04:24 PM
  2. [SOLVED] Remove Duplicates, Partial Removal
    By DorianGrim in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-14-2013, 03:16 PM
  3. [SOLVED] Removal of duplicates, with conditions.
    By Rob8489 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-07-2013, 10:07 AM
  4. Preventing duplicates in a dynamic range
    By garyi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-18-2011, 04:13 AM
  5. Complete removal of duplicates?
    By dan hs in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-10-2009, 07:03 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