+ Reply to Thread
Results 1 to 5 of 5

Macro to Find unique values in three columns

  1. #1
    Registered User
    Join Date
    05-21-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003
    Posts
    2

    Macro to Find unique values in three columns

    Hi,
    I am a newbie to excel macro. I need to write a macro for finding unique values between columns A,B,C. That means I need maco to write values which are unique in these three columns to column D.

    Can any one help me in this...

    Thanks a million.

  2. #2
    Registered User
    Join Date
    05-21-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Macro to Find unique values in three columns

    Quote Originally Posted by RahulRaman View Post
    Hi,
    I am a newbie to excel macro. I need to write a macro for finding unique values between columns A,B,C. That means I need maco to write values which are unique in these three columns to column D.

    Can any one help me in this...

    Thanks a million.
    Here is wer I've reached....
    Please Login or Register  to view this content.

    cn anybody tel me is it right or wrong...?
    Last edited by royUK; 05-21-2009 at 06:49 AM. Reason: add code tags

  3. #3
    Forum Contributor
    Join Date
    02-23-2006
    Location
    Near London, England
    MS-Off Ver
    Office 2003
    Posts
    770

    Re: Macro to Find unique values in three columns

    If it works it is right, if it doesn't it is wrong.
    What is definitly wrong is you need to wrap your code in Code Tags.
    Edit your post, click 'Go Advanced', select your code, and then click the [#] button above the edit area.
    If you find the response helpful please click the scales in the blue bar above and rate it
    If you don't like the response, don't bother with the scales, they are not for you

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Macro to Find unique values in three columns

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Macro to Find unique values in three columns

    Quote Originally Posted by Phil_V View Post
    If it works it is right, if it doesn't it is wrong.
    What is definitly wrong is you need to wrap your code in Code Tags.
    Edit your post, click 'Go Advanced', select your code, and then click the [#] button above the edit area.
    Thanks for the tags prompt.

    Agreed if it works it's right - RahulRaman check your code

    However, code can often work but be written to work more efficiently. I would automate AdvancedFilter -> Unique Values & copy to the required column..

    Attach a workbook with example data for further help

+ 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