+ Reply to Thread
Results 1 to 3 of 3

HELP: How to find which combo appears most often ?

  1. #1
    Registered User
    Join Date
    06-02-2012
    Location
    Romania
    MS-Off Ver
    Excel 2010
    Posts
    95

    HELP: How to find which combo appears most often ?

    I have the following Excel file:
    Most_repeated.xlsx

    I want to find out what are the combos of 2, 3, 4, 5 and 6 numbers which appears most often.

    Any help, please ?

    Thank you so much !

  2. #2
    Registered User
    Join Date
    08-29-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    88

    Re: HELP: How to find which combo appears most often ?

    Not sure if something like this you are looking for

    Thanks
    Dienesh
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-02-2012
    Location
    Romania
    MS-Off Ver
    Excel 2010
    Posts
    95

    Re: HELP: How to find which combo appears most often ?

    Quote Originally Posted by dinesh_ltjd View Post
    Not sure if something like this you are looking for

    Thanks
    Dienesh
    No, I want it like this:
    Please Login or Register  to view this content.
    It should get to me:
    1 1 3 5 appears geometer for 18 times.
    1 1 - appears together for 72 times.
    1 1 1 - appears together for 32 times.
    1 3 5 - appears together for 92 times.
    3 5 - appears together for 37 times.
    3 5 8 - appears together for 23 times.
    and so on.
    Results are given as example and I don't know if they correctly corespondent to the table above.

    Could you do this, please ?

    Thanks in advance !

+ 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