+ Reply to Thread
Results 1 to 6 of 6

checking duplicate in multiple column in VBA?

  1. #1
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    checking duplicate in multiple column in VBA?

    hi,

    how can I add column 1,2,3 here instead of column 3 only?
    I want to compare three column to get the unique value.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Re: checking duplicate in multiple column in VBA?

    awaiting for someone to help on this.

    One way is to add, a new column at the begging & do the concatenate of 1,2,3 column & use that column and later on delete it(created column).

    Is this good enough?

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,748

    Re: checking duplicate in multiple column in VBA?

    1) Strongly recommend not to use "str" as a variable name, since vba has Str function.
    2) try change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Re: checking duplicate in multiple column in VBA?

    Quote Originally Posted by jindon View Post
    1) Strongly recommend not to use "str" as a variable name, since vba has Str function.
    2) try change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Many many thanks, its perfect.

    Please Login or Register  to view this content.

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,748

    Re: checking duplicate in multiple column in VBA?

    You are welcome and thanks for the rep.

    Please mark the thread as "Solved".

  6. #6
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Re: checking duplicate in multiple column in VBA?

    Sure,I'm marking it as solved.

+ 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. [SOLVED] Checking a duplicate in a concatenated column
    By asitiz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2019, 02:05 PM
  2. Duplicate checking
    By JoshJ in forum Excel General
    Replies: 3
    Last Post: 12-09-2013, 06:46 PM
  3. Multiple column checking
    By lovinguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2013, 10:49 PM
  4. [SOLVED] Duplicate Checking
    By chris.slater in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-31-2013, 02:28 PM
  5. Replies: 3
    Last Post: 08-11-2010, 11:42 AM
  6. Checking column for duplicate values and appending
    By Elmer in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-11-2008, 07:25 PM
  7. Checking for duplicate entries over multiple worksheets
    By madbloke in forum Excel General
    Replies: 2
    Last Post: 05-11-2006, 07:56 AM

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