Results 1 to 5 of 5

Removing Duplicates (Advanced)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    100

    Removing Duplicates (Advanced)

    Hello --

    Attached is a workbook that has two different tabs in which I need help removing duplicates, both based on different criteria.

    Tab "Example1" :
    I want column D to say "Keep" if B=C
    I want column D to say "Keep" if B is Blank and C has a date


    Tab "Example2":
    There are duplicate values here based on column A
    If B is Blank and C has a date, keep that row and remove the other rows associated to that same unique key in column A
    If both B and C has a date, delete rows associated to those with the same matching unique key in column A

    Attached is the example.
    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. Remove Duplicates from Advanced Filter Results
    By joedrummer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-24-2013, 11:56 AM
  2. Advanced highlighting of duplicates with conditional formatting
    By Dandy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2012, 05:55 PM
  3. Replies: 6
    Last Post: 03-29-2012, 12:16 AM
  4. Counting duplicates [Advanced]
    By zb134 in forum Excel General
    Replies: 0
    Last Post: 06-22-2011, 09:41 AM
  5. Advanced Sorting, Deletion of Duplicates
    By dualpixel in forum Excel General
    Replies: 4
    Last Post: 05-11-2007, 12:36 PM

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