Announcement

Collapse
No announcement yet.

List All Possible Combinations For Numbers 1-10

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • List All Possible Combinations For Numbers 1-10



    Hi,
    I need help to list out all the combination in the excel. For example, now i have (1,2,3,4,5,6,7,8,9,10)
    How do i list all the combination in the excel spreadsheet. Thanks

  • #2
    Re: List All Possible Combinations For Numbers 1-10

    You will run out of rows. Assuming you want the numbers grouped in groups of 10 e.g. 1,2,3,4,5,6,7,8,9,10 and then 1,2,3,4,5,6,7,8,10,9 etc. Then you will run out of room in Excel about 30% the way through - By my estimation there are 3,628,800 combinations, but only 1,048,576 rows in Excel (2007).

    Also, do a search, or look at "Possible Answers" below as this question has been asked a few times

    Ger

    Check out our new reputation system. Click on the "star" under the post!
    _______________________________________________

    There are 10 types of people in the world. Those that understand Binary and those that dont.

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

    The BEST Lookup function of all time

    Dynamic Named Ranges are your bestest friend

    _______________________________________________

    Comment


    • #3
      Re: List All Possible Combinations For Numbers 1-10

      You could use a Chinese phone book

      Comment


      • #4


        Re: List All Possible Combinations For Numbers 1-10


        Check out our new reputation system. Click on the "star" under the post!
        _______________________________________________

        There are 10 types of people in the world. Those that understand Binary and those that dont.

        Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

        The BEST Lookup function of all time

        Dynamic Named Ranges are your bestest friend

        _______________________________________________

        Comment

        Working...
        X