+ Reply to Thread
Results 1 to 1 of 1

Identifying multiple value combinations

  1. #1
    Registered User
    Join Date
    11-26-2011
    Location
    romania
    MS-Off Ver
    Excel 2003
    Posts
    22

    Identifying multiple value combinations

    Hi,

    Please help me with the following problem.
    In the attached file, I have multiple values in Sheet 1.
    I need to know what are the top 10 (ranked by frequency they occur into the whole sheet, except column A) 3 number combinations (for example 3, 19, 23 - from column B) and where are them in the whole sheet. The combinations are searched only by columns!
    The result I'm expecting is to have a situation that says: 1st place, combination 3, 19, 23 - was found on column C, E, G & J, and so on.



    Thank you!


    PS: Please don't consider the example from attachement gambling related (as other thought..)! I used numbers only to avoid using 80 names. I need help with the above problem in order to establish a hierarchy between my colleagues from sales area.
    Attached Files Attached Files
    Last edited by vicentiu; 07-26-2013 at 11:54 AM.

+ 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. Replies: 4
    Last Post: 03-07-2013, 11:42 AM
  2. Identifying duplicates across multiple tabs with VBA
    By 0nyx1756 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2011, 11:02 AM
  3. Identifying multiple entries.
    By clash005 in forum Excel General
    Replies: 3
    Last Post: 09-30-2009, 07:29 AM
  4. Identifying multiple values within a range
    By proGrav in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-04-2009, 07:40 PM
  5. Identifying multiple entries
    By madtai in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-11-2007, 12:54 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1