Results 1 to 7 of 7

Formula to Tag or Delete Duplicate keeping the Rows with paticular Data

Threaded View

  1. #1
    Registered User
    Join Date
    02-06-2016
    Location
    Manassas, Virginia
    MS-Off Ver
    Office 360 Current version
    Posts
    4

    Formula to Tag or Delete Duplicate keeping the Rows with paticular Data

    Hello to all,

    I'm not the best a complex formula's and need some help

    I need a formula to mark files as duplicate while comparing multiple columns. I have attached an example.

    I have merged 2 different listings of songs. In column "A" I placed a number 1 to indicate the source. Column "B" is the number of the track. Column "C & D" are Title and Artist information. I need to mark the duplicate files as duplicate in Column "E".

    If column "B" and "C" are Equal then mark in column "E" duplicate but only mark the file that doesn't have the "1" in Column A. Then I can sort the duplicates and remove.

    In some cases I compare 2 columns and other times I compare 3 columns so I need to understand how the formula works so I can change it if I need to.

    Thanks for any and all help.

    Chuck
    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. Delete Duplicate Entire Rows Keeping Row with Lowest Price
    By timmy1254 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-23-2015, 07:07 PM
  2. [SOLVED] Move data on duplicate rows (different columns) to one row and delete extra rows?
    By Sagwa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2014, 08:25 AM
  3. Merging Duplicate Rows and Keeping Original Data
    By vinnie179 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-19-2014, 07:18 AM
  4. [SOLVED] how to delete delete rows with criteria and keeping formula
    By Bremmah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2013, 07:09 AM
  5. Delete duplicate rows with same data in certain columns for million rows
    By amlan009 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-08-2012, 12:53 AM
  6. Delete duplicate rows of data
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2010, 01:45 PM
  7. Sum and delete Duplicate Rows VBA MACRO FORMULA
    By ARNO in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-11-2010, 11:56 AM
  8. [SOLVED] Keeping duplicate rows
    By Daniell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2005, 02:06 AM

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