Results 1 to 4 of 4

Macro to give the count of unique values after comparing the comma separated values

Threaded View

  1. 03-02-2014, 03:33 PM #1
    Manish_Gupta
    Manish_Gupta is offline
    Forum Contributor
    Join Date
    08-12-2013
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    147

    Macro to give the count of unique values after comparing the comma separated values

    Hello Guys,

    I need a Macro (not formula) which compares the comma separated values present in Column “I” with individual values present in Column “D” and generate the count of unique values in Column “J”.

    The sample sheet has been attached for reference.

    Many thanks for your help in advance.

    Manish_Gupta
    Attached Files Attached Files
    Last edited by Manish_Gupta; 03-03-2014 at 01:42 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to count values separated by a comma
    By PlamSa in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-19-2013, 09:10 AM
  2. [SOLVED] Count all the unique values in a cell separated by a pipe delimiter, i.e. |
    By Lija in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-10-2013, 11:16 AM
  3. [SOLVED] Macro to match values in cells separated by semicolon and comma
    By Ale84 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2013, 11:00 PM
  4. count of comma separated values
    By bujji1305 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-01-2012, 07:33 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1