+ Reply to Thread
Results 1 to 4 of 4

Excel VBA to find Duplicate Entries with multiple column combination and Display Rows Numb

  1. #1
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Question Excel VBA to find Duplicate Entries with multiple column combination and Display Rows Numb

    Dear all,
    I have a sample data as shown in attached file and i am trying to develop VBA code to identify duplicate entries in column 'A' and 'B' put together.
    A message box must display with duplicate values and their row numbers (as shown box).
    By using formulas and conditional formatting we can identify duplicates and I never tried VBA coding this way before. Can anyone please help me with logic/code.?

    I have around 1000 rows data is similar way and i am sorry if its too challenging to develop.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Excel VBA to find Duplicate Entries with multiple column combination and Display Rows

    Try this:-
    Please Login or Register  to view this content.
    Regards Mick

  3. #3
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Re: Excel VBA to find Duplicate Entries with multiple column combination and Display Rows

    Simply superb... I need to study your logic in detail to understand it... New learning to me...Many many thanks..

  4. #4
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Excel VBA to find Duplicate Entries with multiple column combination and Display Rows

    You're welcome

+ 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. Transpose rows to column for duplicate entries
    By adada123 in forum Excel General
    Replies: 4
    Last Post: 03-22-2015, 02:42 AM
  2. Replies: 9
    Last Post: 12-03-2014, 04:47 AM
  3. Replies: 5
    Last Post: 11-09-2011, 01:01 PM
  4. Display duplicate entries in excel
    By tsr_83 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-28-2010, 02:56 AM
  5. Find Duplicate Entries by Column
    By cheryl_allison in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2005, 09:05 PM
  6. WHAT COMBINATION OF A SET OF NUMBERS COMES CLOSEST TO A FIXED NUMB
    By RED in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-05-2005, 02:06 PM
  7. [SOLVED] I want to delete rows with duplicate entries within one column.
    By kini olegario in forum Excel General
    Replies: 1
    Last Post: 01-14-2005, 10:07 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