+ Reply to Thread
Results 1 to 3 of 3

remove duplicates based on adjacent cell value

  1. #1
    Registered User
    Join Date
    01-19-2015
    Location
    Lafayette, LA
    MS-Off Ver
    2007
    Posts
    9

    remove duplicates based on adjacent cell value

    I have a worksheet with data in columns A thru I and a total of 5859 rows. The data in column F should be unique but there are duplicates that I need to remove based on the value in column H. Column F is a alpha numeric serial number and column H is a date. If there are 10 duplicates (ten rows with same serial number in column F) then I want to remove the rows with the oldest date and keep the row with the newest (most recent) date. Please help

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: remove duplicates based on adjacent cell value

    Hi,

    Can you upload a sample of your workbook, take a copy and remove all but a representative number of rows, so that we can see the request in context. Manually add the results you expect to see and tell us which are the results and which data.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-19-2015
    Location
    Lafayette, LA
    MS-Off Ver
    2007
    Posts
    9

    Re: remove duplicates based on adjacent cell value

    Sorry, after further thought I realized I was over thinking this. So I just sorted by the serial then by date (oldest first) then in the next column i ran the following formula:
    =IF(F2=F3,"DELETE","SAVE")
    This would put the word "DELETE" if that row needed to be removed then I copied and pasted the values (removing the formulas) then sorted by that column and delete all rows with that "DELETE" value.
    Done.
    Thanks again and maybe this will help someone else too :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Code to remove duplicates based on a criteria
    By twizy in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-17-2014, 09:48 AM
  2. how to remove adjacent value to duplicates in another column
    By genetist in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-04-2014, 04:12 AM
  3. [SOLVED] How to search and remove a series of entries based on adjacent values.
    By Excel Trier in forum Excel General
    Replies: 16
    Last Post: 02-15-2014, 01:28 AM
  4. fill/ remove formula based on adjacent cell value
    By sarails in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2011, 10:38 PM
  5. Remove duplicates based on criteria
    By keswickjeff in forum Excel General
    Replies: 2
    Last Post: 07-14-2011, 12:15 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