Ask a Question
or
Create a Poll
  1. Home /
  2. Questions /
  3. Computers
  4. / Computer Software
  5. / Spreadsheet Software
  6. / Microsoft Excel

by SnakeEyez on March 3rd, 2009

SnakeEyez

Question

Help answer this question below.

Is it possible for me to create a list, in Excel, of all possible number combinations between 1-33?

  • Like
  • Report
Share:
Other

Answers. 2 helpful answers below.

  • by Cyanotic Wasp on March 5th, 2009

    Cyanotic Wasp

    Of course "it's possible", but I can't imagine right now how you'd do it -- or why -- and maintain your sanity.

    Let's assume that by "all possible number combinations" you mean "integers only". That's still a lot of possible permutations.

    For example, consider the possible combinations of integers from 1 - 5 as:

    1
    2
    1 + 2
    3
    1 + 3
    1 + 2 + 3
    2 + 3
    4
    1 + 4
    1 + 2 + 4
    1 + 3 + 4
    1 + 2 + 3 + 4
    2 + 4
    2 + 3 + 4
    3 + 4
    5
    1 + 5
    1 + 2 + 5
    1 + 2 + 3 + 5
    1 + 2 + 3 + 4 + 5
    2 + 5
    2 + 3 + 5
    2 + 4 + 5
    2 + 3 + 4 + 5
    etc.

    and that's not even a complete list. I just quit because I'm getting dizzy.

    No comments. Post one | Permalink

  • by Brian I on March 3rd, 2009

    Brian I

    Type the number 1 in cell A1, drag the fill-handle down to cell A33 with the right mouse button and select 'Fill Series' from the menu that appears.

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

You're reading Is it possible for me to create a list, in Excel, of all possible number combinations between 1-33?

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

ANSWERBAG BUZZ

Excel all possible combinations in a list
Excel formula all possible combinations words
List of all the possible combinations between 1 5
Excel 2007 list all possible combinations
Finding all possible combinations

Answerbag

a Demand Media company