+ Reply to Thread
Results 1 to 3 of 3

Amedndment of VBA code to see combo not as unique

  1. #1
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Amedndment of VBA code to see combo not as unique

    I have a macro that goes through Column E-I to count how many times the combination of 3 numbers that appear the most have occurred. I only need an amendment to the code so that the code would write as per example 2 2 1 and 2 1 2 and 1 2 2 as the same combination and count that instance instead of writing it as 3 different combos. Hope that make sense. Rep given to anyone that can help me to achieve this code amendment.Thank you for any help and Rep will be given


    Spreedsheet attached Here is the code

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by ricklou; 11-02-2016 at 05:58 AM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,835

    Re: Amedndment of VBA code to see combo not as unique

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Re: Amedndment of VBA code to see combo not as unique

    Works FLAWLESSLY Great CODER Thank you Jindon REP GIVEN Thanks for your sollution



    Quote Originally Posted by jindon View Post
    Please Login or Register  to view this content.

+ 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. Combo box unique entries
    By ste2610 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-17-2016, 01:21 PM
  2. [SOLVED] Getting Unique Values Into A Combo Box
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2014, 12:45 PM
  3. VBA combo box add unique values only
    By randell.graybill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2014, 11:14 PM
  4. Code to populate combo box with unique entries from column (in alphabetical order)
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 34
    Last Post: 01-26-2014, 03:05 AM
  5. [SOLVED] list of duplicate code along with unique manager name want to split unique
    By sinha.riteshabap in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-21-2013, 07:00 AM
  6. combo box user form code for two combo boxes
    By robert.begley1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-01-2012, 02:25 PM
  7. Unique value data combo box
    By herukuncahyono in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2009, 12:15 AM

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