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

Password?

Password is

pinku1234:)

Quote:

---

Originally Posted by santoshdream

Password is

pinku1234:)

---

Nope. Please post an unprotected sheet.

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.