Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: List All Possible Combinations For Numbers 1-10

  1. #1
    Join Date
    19th July 2010
    Posts
    1

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    16th June 2005
    Location
    Dublin
    Posts
    4,491

    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
    _______________________________________________
    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

    _______________________________________________

  3. #3
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,707

  4. #4
    Join Date
    16th June 2005
    Location
    Dublin
    Posts
    4,491

    Re: List All Possible Combinations For Numbers 1-10

    _______________________________________________
    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

    _______________________________________________

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Create All Possible Combinations Of X Numbers
    By ehavs79 in forum EXCEL HELP
    Replies: 4
    Last Post: May 10th, 2008, 11:49
  2. Every Possible SUM Of X Numbers Combinations
    By Arnaldo in forum EXCEL HELP
    Replies: 3
    Last Post: February 2nd, 2008, 23:36
  3. Combinations From Set Of Numbers
    By kamland in forum EXCEL HELP
    Replies: 9
    Last Post: January 5th, 2007, 05:11
  4. All Combinations From Series Of Numbers
    By 21MSU in forum EXCEL HELP
    Replies: 2
    Last Post: August 14th, 2004, 09:29

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
  •  
porno