+ Reply to Thread
Results 1 to 6 of 6

A combination of 3 numbers that appear most

  1. #1
    Registered User
    Join Date
    08-30-2008
    Location
    israel
    Posts
    61

    A combination of 3 numbers that appear most

    Hello everyone !

    I need to find a combination of 3 numbers frequently appears.

    Thank you !
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: A combination of 3 numbers that appear most

    Hi,

    You'll need to explain a little more. Confirm which cells are original data, which are the results and how you have calculated the results.

  3. #3
    Registered User
    Join Date
    08-30-2008
    Location
    israel
    Posts
    61

    Re: A combination of 3 numbers that appear most

    Hi Richard,

    The data are in rows, each row has six numbers, the combination of three numbers, not necessarily linked to each other in the ranks of the data, the solution is possible in one cell or three cells.

    Thank you!

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: A combination of 3 numbers that appear most

    Sorry but I still have no idea as to how you choose the numbers you want for the results.

    We're not psychic - least not all the time and you need to explain your thought process when you do this manually. Often we can imply how you've arrived at results if it's reasonably obvious but with this I have no idea at the moment. You need to help us to help you.

  5. #5
    Registered User
    Join Date
    08-30-2008
    Location
    israel
    Posts
    61

    Re: A combination of 3 numbers that appear most

    Hi Richard,

    The data are random at the moment, since I have still the desired formula, then I found these
    two solutions without formula

  6. #6
    Registered User
    Join Date
    08-30-2008
    Location
    israel
    Posts
    61

    Re: A combination of 3 numbers that appear most

    I did not think the question is so complicated !
    Find 3 trio of numbers that appears most, in six columns .

+ 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. Finding right combination of numbers
    By shocktrop in forum Excel General
    Replies: 3
    Last Post: 09-11-2011, 02:13 AM
  2. combination of these numbers would sum
    By alisapooh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-22-2009, 12:27 PM
  3. [SOLVED] matching a combination of numbers
    By mike in forum Excel General
    Replies: 2
    Last Post: 06-28-2006, 05:00 PM
  4. [SOLVED] combination of numbers
    By dc in forum Excel General
    Replies: 0
    Last Post: 06-08-2006, 02:55 PM
  5. combination of numbers
    By ErnestoMarti in forum Excel General
    Replies: 36
    Last Post: 10-23-2005, 05:05 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