Results 1 to 2 of 2

Remove duplicates by condition

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-13-2017
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    107

    Remove duplicates by condition

    Hi,

    I have a file with multiple columns and rows.
    Some rows are exactly the same except 1 column.

    Example attached.
    If the name of the person in column C is the same,column B is 1x blanc and 1x filled in.

    I would like to check for duplicates in column C and remove the row where column B is empty.
    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. Compare lists of URLs for duplicates, and remove duplicates
    By mrfranklin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-25-2021, 02:54 AM
  2. Replies: 6
    Last Post: 11-27-2018, 07:17 AM
  3. Replies: 6
    Last Post: 10-19-2018, 02:44 PM
  4. How To Remove Duplicates On Specific Condition?
    By TechnicGeek in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-15-2014, 02:12 PM
  5. Replies: 1
    Last Post: 10-23-2012, 09:12 AM
  6. Replies: 5
    Last Post: 02-28-2012, 02:52 PM
  7. Replies: 2
    Last Post: 03-20-2011, 11:19 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