Question about Microsoft Computers & Internet

5 Answers

Permutation formula I need to list out all the combinations of numbers 1 to 9 which can be achieved with 6 spaces. I know you can use CHAR to do this but only have an example which shows 12 letters into combinations of three. I am unsure how to expand this to combinations of six with only 9 possibilities. Can you help?

Posted by sueplant on

  • 5 more comments 
  • sueplant Aug 13, 2008

    Thanks for your help but I know how to calculate how many permutations I will get what I need is to list each one of them out in 6 columns on an excel spreadsheet so I need formula to post that I can fill down in each column.

    eg 111111, 111112, 111113, 111114 ... 223456 etc and so on there should be 9x9x9x9x9x9=531,441 permutations in my final list with none repeating.

  • sueplant Aug 13, 2008

    I am using Microsoft excel version 2007. The CHAR I refer to is a formula option like ROUND or PERMUT. Sorry for the confusion.

  • sueplant Aug 13, 2008

    I have been e-mailed to tell me that there is a new comment on this problem but there is nothing new here!!

  • sueplant Aug 14, 2008

    I have not really had a response to this problem yet. Can anyone help as I need to get this list pronto!!

  • sueplant Aug 14, 2008

    Thanks to all who have answered but you have all told me how to calculate how many permutations which I already know. I need formula to put at the top of each column in cells a1 to f1 which I can then fill down to give me a long column of all the combinations
    eg
    111111
    111112
    111113
    111114

    I have the formula for picking three alphabetical characters from ABCDEFGHIJK.

    In cell A1 type =CHAR(65+TRUNC((ROW()-1)/144))
    In cell B1 type =CHAR(65+MOD(TRUNC((ROW()-1)/12),12))
    In cell C1 type =CHAR(65+MOD(ROW()-1,12))

    This does work but I do not know how to expand it to 6 columns with 9 options. I know that CHAR 49 is the ASCII ref for number 1 and 50 is for number 2 etc so I can substitute that and I assume that the 12 will be replaced with 9 but apart from that I do not understand the logic of the formula.

    I hope this helps you find me a solution.

    Sue

  • sueplant Aug 14, 2008

    Sorry I am new to the site. If an expert just sends a comment that says I know tha answer how do I look at it without knowing what it is?

  • sueplant Aug 14, 2008

    Solved problem myself thankyou. No need to further respond.

×

Ad

5 Answers

robert patterson

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

How many combinations of 6 numbers are there in the 20 numbers
as set out here . 2.4.6.12.18.20.24.26.28.30
5.7.9.15.17.21.23.25.29.31

Posted on Nov 10, 2013

Ad

Asfiya Ahamed

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Genius:

    An expert who has answered 1,000 questions.

  • Master
  • 1,011 Answers

Dear Sir/madam,

Read out the formula with examples of the Ms-word Help Menu. PERMUT, COMBIN. It will all teach you......


thanks
good luck

Posted on Aug 14, 2008

Ad

Anonymous

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 133 Answers

U have to go with a professional

Posted on Aug 14, 2008

Louie Role

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Brigadier General:

    An expert that has over 10,000 points.

  • Master
  • 6,966 Answers

Hi,

Have you tried "PERMUT" using MS Excel?

Hope this be of initial help/idea. Pls post back how things turned up or should you need additional information.

Good luck and kind regards. Thank you for using FixYa.

Posted on Aug 13, 2008

Ginko

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 19,396 Answers

1 to 9 sounds wrong, it should ben 10 to 9 if it is permutation order 10

Posted on Aug 13, 2008

  • Ginko
    Ginko Aug 13, 2008

    Please tell me software brand of your char software, on the market we have many char software packages, and I need further information.

    Many thanks


×

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

5 number combination list


Too many to list (3,125). It would take you forever to get it unlocked. I would suggest bolt cutters and just spend the 20-30 bucks to buy a new one.

Aug 22, 2014 | Kensington Black Portable Combination Loc

1 Answer

Number combinations


One-number combinations: { 1 2 6 9 }
Two-number combinations: { 12 16 19 26 29 69 }
Three-number combinations: { 126 129 169 269 }
Four-number combinations { 1269 }

Or did you want permutations?

Jul 07, 2014 | Computers & Internet

1 Answer

I have 6 digits, numbers 1-6 need to list all combinations possable


There's only one six-digit combination possible, namely the digits 1, 2, 3, 4, 5, and 6.

If the order matters then there are 720 possible permutation. I'm not going to list them all. Start with 123456, then 123465, 123546, and so on to 654312 and 654321.

Mar 25, 2014 | Computers & Internet

2 Answers

Does anybody know how many different combinations there are for the numbers 1, 2, 3, 4, 5 and 6?


That depends on how many of those six numbers you take.
If you only take one number, there are six combinations: {1}, {2}, {3}, {4}, {5}, and {6}.
If you take two numbers, there are fifteen combinations: {1,2}, {1,3}, {1,4}, {1,5}, {1,6}, {2,3}, {2,4}, {2,5}, {2,6}, {3,4}, {3,5}, {3,6}, {4,5}, {4,6}, and {5,6}.
If you take three numbers, there are twenty combinations.
If you take four numbers, there are fifteen combinations.
If you take five numbers, there are six combinations.
If you take all six numbers, there is only one combination: {1,2,3,4,5,6}.
In general, if you take 'm' objects out of a set of 'n' objects, the number of combinations is given by n!/[(m!)(n-m)!] where '!' is the factorial operator.

Apr 30, 2013 | Mathsoft Computers & Internet

1 Answer

I need the assembly manual for a char-broil LP Gas Grill model # 4638975. Much appreciated!


The model number you listed 4638975, does not match any current Char-Broil models.
Please check again, confirm and let me know the correct model number.

Thanks for choosing FixYa.

Sep 20, 2011 | Char-Broil CharBroil Master Flame Gas...

1 Answer

On a 12 lead generator to achieve 480volts. would i have to tie 4 -7 5-8 6-9. 10 11 12 to neutral. and 1 2 3 are line leads. i can get 240 volts from my center taps, for my regulator. cause line to...


The terminals you listed are correct.
T4 -T7 mated
T5 -T8 mated
T6 -T9 mated
10, 11, 12 combined connection

L1, L2, & L3 = output / line leads

However you should have 277 VAC line to ground and 480 VAC Line to line (Across any 2 phases)

So terminals 1, 2 or 3 to ground should be 277 VAC (L1 L2 or L3)
1-2 or 1-3 = 480 VAC
any combination of
1 , 2, or 3 to each other = 480 VAC

As a "generator man" with 19 solutions one being "You might have to sting it" you should know this and be able to use the diagram on the power head to get your desired voltages unless the wiring data plate is missing. I have had to dial in voltage regulators when switching between 240 and 480 to prevent automatic shut downs from over / under voltage.

Kelly

Sep 18, 2011 | Electrical Supplies

1 Answer

About how to shortcut examples in alphabet or in sve or open then something about that


Internet browsing requires rubics discused
1. the appropiate words have to typed into the search spaces to achieve any list of results.
2. the search spaces on the internet browsers allow only certain alphebet and number combinations.
3. A symbol typed into the search spaces could generate a list of codes humanly undiciperable

Dec 06, 2010 | Hitachi Computers & Internet

2 Answers

MAYTAG FREEZER CAPACITY


I cannot find a MQU8057AEW in the Maytag library. I did find a MQU2056AEW that is 20 cu ft.

May 05, 2010 | Maytag 20 cu. ft. Upright Freezer MQU2056B

2 Answers

Removing junk from the T9 word list


just change the T9 to english or ienglish.

Mar 06, 2008 | Samsung SYNC SGH-A707 Cellular Phone

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

455 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Lee Hodgson
Lee Hodgson

Level 3 Expert

4810 Answers

efs_perpends
efs_perpends

Level 3 Expert

1997 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...