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

×

5 Answers

  • 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

  • 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

  • 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

  • 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

  • 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


×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

How to calculate a permutation problem in a lottery of 1 - 45 digits


I assume you are looking for the number of combinations of 1 - 45 where the first number is one of the 45, the second number is one of the remaining 44, etc. The answer is 45 factorial (i.e x=45*44*43*...*2*1). The Excel formula Is =FACT(45).

Jul 09, 2009 | Microsoft Excel for PC

10 Answers

In Excel adding positive and negative numbers


Yes,


  1. Select the column. (click on top of the column it will select)
  2. Right Click and select Format Cells.
  3. Select Currency in Category then press OK
b6298df.gif Now just type your Numbers i.e. 571 for $571 and -650 for -$650 and sum using the normal way.

That is Select the Cells which you want to SUM and Press Alt+=

This will bring the total just below the selected cells.

Thanks
Iqbal

Apr 02, 2008 | Computers & Internet

1 Answer

SERIAL NO OF BILL


Place the numer to be update in one cel
In anither cel say cel=cel+1 because of the alpha "S" here you need to combine 2 things.
3 formulas in excel.
right string
add 1 to val(3charactersfromright)
combining s with converted new serialnumer
Personally I prefer Foxpro for these tasks.
For large amount of numbers this is no excel task.
Have no english excel here. Look up the easy function types.
You need no visual basic for this.

Apr 10, 2009 | Microsoft Excel for PC

1 Answer

Finding the correct row num


You would have to combine the use of 2 functions. The Address and Match funbctions.
Lets say the number you want the address of is located in cell F1 and you have 2 columns of numbers. One colum in Column A and the other in column B. I will give you 2 formulas. The 1st one will return just the row number. The 2nd one will return the cell address.

Option 1: Lets say you just want to know the row reference of the number in cell F1. Place this formula in cell D1. =MATCH(F1,A1:A20)
If you have another column ytou want the row number of, place the formula in lets say cell D2 and change the column references from 'A' to 'B'.

Option 2: If you want the cell reference, place this formula in cell D1 and D2 instead of the firt formula.
=ADDRESS(MATCH(F1,A1:A20,0),1,1,TRUE)
And just like the first option, for the 2nd column, put the formula in D2 and change the column reference 'A' to 'B'.

Feb 17, 2009 | Microsoft Excel for PC

1 Answer

BASIC EXCEL FORMULA


Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

columns: A B C D
rows
1 20 3
2 10 4
3 15 2
4 1 2 3


Then suppose you type in the following formulas (in the D column):

columns: A B C D
rows
1 20 3 =A1+B1
2 10 4 =A2-B2
3 15 2 =A3*B2
4 1 2 3 =sum(A4:C4)


Then the following answers will appear in the D column:

columns: A B C D
rows
1 20 3 23
2 10 4 6
3 15 2 30
4 1 2 3 6

Sep 29, 2008 | Microsoft Computers & Internet

1 Answer

Percentages in Excel


No problem, Melinda, I am here to help!

If I understood correctly, your spreadsheet looks something like this:
A B C D
1 Question Yes No Total
2 Is sky blue? 20 2 22
3 Is world round? etc.

In this case, the formula for % of Yes would be: =B2/D2. This would give you a decimal point result such as 0.909091. Now if you want to make this look like a percentage in your spreadsheet, just do the following:
1) click on the cell where you have the division formula
2) clck on Format in the top menu bar
3) click on Cells
4) click on the Number tab (if you're not already there)
5) click on Percentage in the list of categories
6) click OK

To boil it all down to a simple principle, percentages are created in Excel by dividing the two numbers using a formula with "/" in it, and then formatting the result to look like a percentage instead of a decimal.

I might have misunderstood your question, and I have an idea of what else you might have been asking (and another slightly more complicated solution for it!), so please let me know if my first answer didn't hit the mark!

Good Luck!
Regards,
RichMTech

Aug 08, 2008 | Microsoft Excel for PC

1 Answer

Work day


Hi Chinnu,

For this you will have to install an Add-in called Analysis Tool Pack.

Kindly follow the below instructions:

1. Open Excel Options (Menu-Excel Options)
2. Click on Add-Ins on the side pane of the Excel Options Window
3. Check to see if Analysis ToolPak is in Inactive application add-in list.
4. If is not, proceed to Step 7
5. If it is in the inactive application add in list, Select Excel Add-ins against Manage and click on "Go"
6. In the add-ins menu check Analysis ToolPak and Analysis ToolPak VBA and click OK
7. Use this formula to find the number of work days excluding Saturday & Sunday in a month

=NETWORKDAYS(start_date,end_date, [Holidays])

In your case give the start date as 1st July and end date as 10th July and Holidays as 0 or 1 (doesn't matter). The answer it will return will be 8 days.

Trust the above helped.

Jul 23, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Random number generation.


you can use the Round function as below - it rounds out the decimal to 0 places, which gives you 5 digits with no commas

=ROUND(RAND()*100000,0)

Jul 10, 2008 | Microsoft Excel for PC

2 Answers

Display calculation result in a previous cell


Look into the =SUMIF function, it sounds like this may be what you are looking for.

Hope this helps!

Apr 09, 2008 | Microsoft Excel for PC

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

Related Topics:

435 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18333 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...