Permutaion and combination in excel

santoshdream

Registered User.
Local time
Today, 07:47
Joined
Jan 22, 2009
Messages
22
Hi,


I need 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 cant 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.


Regards
Santosh
 

Attachments

Users who are viewing this thread

Back
Top Bottom