+ Reply to Thread
Results 1 to 4 of 4

Identify reoccurring in any combination of value in multiple columns

  1. #1
    Registered User
    Join Date
    04-14-2012
    Location
    atlanta
    MS-Off Ver
    Excel 2003
    Posts
    1

    Identify reoccurring in any combination of value in multiple columns

    yes, please please .....
    is there any program out there that can identify reoccurring in any way combination of value in multiple columns. Note that Values within columns can be different or duplicated the same. It would list out those combination and be counted how many times they have been repeated.
    Please see two attached files for better presentation
    If not , can it be done and how.

    Thank you for your help

    Cell: 404-279-0665
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Identify reoccurring in any combination of value in multiple columns

    Hello zoneone73,

    Welcome to the Forum!

    You need to explain your logic in more detail. After looking at both workbooks, I am unable to see the patterns you have presented.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: Identify reoccurring in any combination of value in multiple columns

    unsure of your requirement, but if you are trying to count how often a value occurs, try a countif() with the criteria being what you want to count?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Identify reoccurring in any combination of value in multiple columns

    Please have a look at the attached.

    I've done a preliminary sort on each row and then used a binary string to pick out the replicated combinations of three members or greater. Hit the go button to run the code.

    Code is shown below.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Martin

+ 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