+ Reply to Thread
Results 1 to 3 of 3

Concatinate and remove duplicates using vba macro using autofilter criteria

  1. #1
    Registered User
    Join Date
    08-05-2013
    Location
    bangalore
    MS-Off Ver
    Excel 2003
    Posts
    8

    Concatinate and remove duplicates using vba macro using autofilter criteria

    1 2 3 4 5 6 7

    car A apple1 orange1 22 23 24
    bat A apple1 orange1 12 34 56
    bus A grape1 cherry1 13 56 67
    cat A grape1 cherry1 23 45 78
    fat B peach1 mango1 12 13 14
    van B peach1 mango1 13 24 16
    gun B berry1 banana1 13 67 99

    1..Here i hav apply auto filter for 2nd field ie A and B, and i should enter the Criteria for the autofilter through message box
    2..If I enter A , here the 5th col value should be concatinated,for the repeated rows,
    out put :
    car A apple1 orange1 22/12
    bus A grape1 cherry1 13/23



    3...if i enter B,
    fat B peach1 mango1 12,13,14/13,24,16
    gun B berry1 banana1 13,67,99


    Please find solution for this
    Last edited by chakravarthysm; 08-06-2013 at 12:21 PM. Reason: not able to recognise the data for a perticular row

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Concatinate and remove duplicates using vba macro using autofilter criteria

    Hi

    i will get back to you tmrow
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,099

    Re: Concatinate and remove duplicates using vba macro using autofilter criteria

    Hi, chakravarthysm,

    you would need to elaborte why Column A should be neglected and why for character A only Column E should be concatenated while for B the Columns E to G should be concatenated. Are there more of these special cases to care for? Maybe you should attach a workbook with sample data and explain hte basic data, the list of which character will concatenate which column/columns and a sample how the data should look like.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ 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. Macro to remove duplicates (If duplicate meets all three criteria)
    By adw223 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2013, 05:46 PM
  2. Remove Duplicates with Criteria
    By cowtipper in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-08-2013, 05:40 PM
  3. [SOLVED] concatinate cells and remove duplicates
    By wellsw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2013, 07:54 PM
  4. Remove duplicates based on criteria
    By keswickjeff in forum Excel General
    Replies: 2
    Last Post: 07-14-2011, 12:15 PM
  5. Macro to remove duplicates values and keep unique values bases on multiple criteria
    By Ricker090 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2011, 04:37 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