+ Reply to Thread
Results 1 to 6 of 6

Comparing various duplicate numbers and data assocaited with them

  1. #1
    Registered User
    Join Date
    06-19-2008
    Posts
    4

    Comparing various duplicate numbers and data assocaited with them

    Hi,

    Here is my issue. I have a spreadsheet like the example below. What I want is to get rid of the duplicate ssn line that has the oldest date in the "process" column. So for this example I want to get rid of the entire line 2nd line. I can come up with some longer ways of doing this but it seems as if there should be a quick way. Thanks!

    Number ------ Date ---------- Process
    123456 --- 02/05/2006 --- 06/05/2008
    555555 --- 01/01/2007 --- 06/01/2008
    555555 --- 05/27/2008 --- 06/08/2008

  2. #2
    Registered User
    Join Date
    05-21-2008
    Posts
    24
    When you say "Get rid" do you mean permanently delete that row?

  3. #3
    Registered User
    Join Date
    06-19-2008
    Posts
    4
    Quote Originally Posted by Tracer123
    When you say "Get rid" do you mean permanently delete that row?
    Yes. If you take the two rows with the same "number" I want to delete the one on my spreadsheet that has the oldest "process" date. My spreadsheet has thousands of lines, just using this as a small example.

  4. #4
    Registered User
    Join Date
    06-19-2008
    Posts
    4
    Maybe there isn't a way?

  5. #5
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578
    Did you want this automated (using Visual Basic) or with formulas to weed out the duplicate rows?

    If you can sort (by SSN and process date) you can use this formula in an empty column
    Please Login or Register  to view this content.
    and drag down. Then highlight the entire range including the column with the deletes and autofilter on the deletes, then delete all the visible rows.
    Without sorting will be a bit trickier but I can give it some thought.

    ChemistB
    Last edited by ChemistB; 06-20-2008 at 10:24 AM.

  6. #6
    Registered User
    Join Date
    06-19-2008
    Posts
    4
    Quote Originally Posted by ChemistB
    Did you want this automated (using Visual Basic) or with formulas to weed out the duplicate rows?

    If you can sort (by SSN and process date) you can use this formula in an empty column
    Please Login or Register  to view this content.
    and drag down. Then highlight the entire range including the column with the deletes and autofilter on the deletes, then delete all the visible rows.
    Without sorting will be a bit trickier but I can give it some thought.

    ChemistB
    That is pretty quick and easy. I was using a bunch of ='s formula's that were too time consuming. Thank you very much!!!

+ 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