Ask Experts Questions for FREE Help !
Ask
    santoshdream's Avatar
    santoshdream Posts: 11, Reputation: 1
    New Member
    		  
    #1

    Apr 22, 2009, 02:19 AM
    Permutaion and combination in excel
    Hi,



    I hope you remember me.

    How are you..


    I need one more help in Excel. You can see the attached file.



    I have santosh_com.xls file with code which I am using on a daily basis but in this file I have some limitation like I can't take negative values in my permutaion-combination and also I have limitation where I cannot take more values. If I am taking more values in column A in this sheet my computer system will not work because my computer will be hang if I am taking more than 15 values.



    in attached file santosh1.xls is an example where you can see two blocks. I have to find out the value from Block - A.





    I just want some below mentioned updation in santosh_com.xls.



    1. I want to take negative values in santosh_com for my permutation and combination.

    2. I want to take more digit numbers and values but without my system hang.:D:D

    Regards

    Santosh
    Attached Files
  1. File Type: xls santosh1.xls (14.5 KB, 143 views)
  2. File Type: xls santosh_com.xls (52.5 KB, 149 views)
    3. JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Apr 22, 2009, 12:26 PM

    Password?
    santoshdream's Avatar
    santoshdream Posts: 11, Reputation: 1
    New Member
    		  
    #3

    Apr 22, 2009, 12:39 PM
    Password is

    pinku1234:)
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #4

    Apr 22, 2009, 03:45 PM
    Quote Originally Posted by santoshdream View Post
    Password is

    pinku1234:)
    Nope. Please post an unprotected sheet.
    santoshdream's Avatar
    santoshdream Posts: 11, Reputation: 1
    New Member
    		  
    #5

    Apr 23, 2009, 01:45 AM
    Hi


    I am really sorry for the confustion. Please see the attached copy.

    This sheet is doing exactly the same which I want to do that but I want few changes because this sheet has some limitation like.

    It is not accepting the negative value in column A. if i am entering the negative value in column A, this sheet will not show me the combination.
    and second reason is this sheet is not accepting the million digit value in column A.

    Please help.
    Attached Files
  3. File Type: xls CombinationsRecursive.xls (68.0 KB, 175 views)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.

Combination and Permutation [ 1 Answers ]

How many ways are there of selection three of the same face cards (i.e. 3 jacks, 3 queens, or 3 kings from the face card pile of 12?

Permutationand Combination [ 2 Answers ]

How many different squares are there on a chessboard?

Probabilities and combination [ 1 Answers ]

what is the probability of drawing flushes (5cards) in a deck of cards?

Combination shower fan on GFI [ 1 Answers ]

I am installing a combination fan, light, night light shower fan in a new shower, all of which are on separate switches. The electrician pulled all three switches to the panel box. It sounds to me that I will need to install 3 GFI breakers. Will I need to have all 3 on separate GFI breakers? What...

View more questions Search