Results 1 to 3 of 3

How to remove duplicates

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    hyderabad
    MS-Off Ver
    Excel 2010
    Posts
    18

    How to remove duplicates

    Please find the attachment.

    I want to remove the duplicaes.

    in the column B some of the no.s are duplicate, in that i want to remove the dupliacate with old date (Date is in column A).

    So, here B2 having 11396 and it is repeated in B3, where as for B2 is older than b3 (B2 is older becuase of the date in A2).

    So i want to delete old date and i want to keep the new from the duplcates.

    Can you help me on this.

    Better please try to use formula if not Macros.

    Thank you.
    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. Replies: 1
    Last Post: 10-23-2012, 09:12 AM
  2. Replies: 5
    Last Post: 02-28-2012, 02:52 PM
  3. Need VBA code to remove entries if there are duplicates (remove them totally)
    By BrandonFromSingapore in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2012, 12:50 AM
  4. Replies: 2
    Last Post: 03-20-2011, 11:19 AM
  5. remove duplicates doesn't remove A1
    By chrx74 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-08-2007, 05:02 PM

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