+ Reply to Thread
Results 1 to 3 of 3

"conditional" duplicate removal

Hybrid View

  1. #1
    Registered User
    Join Date
    11-08-2007
    MS-Off Ver
    2021 Prof
    Posts
    85

    "conditional" duplicate removal

    I have a excel data base that has data entered from various sources and therefore sometimes ends up with some duplicate entries.

    Each row has a special ident number so the total row is not duplicated.. only the data after the ident number.

    How can I test the total row to see if it is a duplicate(other than the ident) and delete other than the first appearance, and keep its ident number intact.

    I tried the unique filter but that seems to apply to the entire row

    Thank to all

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,523
    Hi,
    Are you not able to select the range with the advanced filter?
    http://office.microsoft.com/en-us/ex...346261033.aspx

    Here are some codes for deleting duplicate rows
    http://www.cpearson.com/excel/deleting.htm

  3. #3
    Registered User
    Join Date
    11-08-2007
    MS-Off Ver
    2021 Prof
    Posts
    85

    Criteria

    I cant work out how? I need to check the row(minus my row file number) againast all others for adup row, then copy the entire row

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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