+ Reply to Thread
Results 1 to 5 of 5

Find Duplicate data

  1. 08-02-2009, 11:21 PM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Find Duplicate data

    Please see attached sheet..

    Column A has File Name..
    Need to highlight the duplicate data as you can see there is 2 duplicate data which i have manually highted ( C19 is duplicate of C12, C83 is duplicate of C84)


    Let me know if any questions,

    Thank you

    Riz
    Attached Files Attached Files
    Last edited by rylo; 08-03-2009 at 10:04 PM.
    Reply With QuoteRegister To Reply
  2. 08-02-2009, 11:38 PM #2
    rylo
    rylo is offline
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Find Duplicate data

    Hi

    See how this goes.

    Please Login or Register  to view this content.
    rylo
    Reply With QuoteRegister To Reply
  3. 08-02-2009, 11:47 PM #3
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Find Duplicate data

    Thank you so much ...this works great...

    Is it possible to add Message Box :" Duplicates highted...Do you want to delete" Y or N.

    If Y is seleceted then delete the row with duplicate data...
    If N then keep it highlighted...

    Thank you

    Riz
    Reply With QuoteRegister To Reply
  4. 08-03-2009, 12:40 AM #4
    rylo
    rylo is offline
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Find Duplicate data

    Hi

    Here 'tis.
    Please Login or Register  to view this content.
    rylo
    Reply With QuoteRegister To Reply
  5. 08-03-2009, 03:20 PM #5
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Find Duplicate data

    This works great for me....

    Thank you..

    Riz Momin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1