Zhoney

[ZHONEY]

Currenlty I Am Facing A Problem

Its Like I Have So Many Values In Columns Which I Have To Match Against A Single Figure Which Is A Combination Of 2 Or 3 Values Or More

For Example Amount Is 1000

It Is The Comination Of Say 500+300+200

Which Equals To 1000 Which I Wanted To Search

So Is There Any Code For This That I Can Match A Single Value Against Its Cobination From A Column Or Whole Sheet


I M In Real Trouble Now

If Anybody Can Help

I L Be Really Thankful

[mangesh_yadav]

You may simply say if cell value = 1000. What exactly are you looking for.

- Mangesh

[ZHONEY]

i m looking for if i need to search 1000 from no of values in a column and tht 1000

is basically combination of more than 1 figures


so i want a code which will search the whole column and return me the figures

which combine to make 1000


if you can help me in this regards i l be thankful

[mangesh_yadav]

Hi Zhoney,

I guess your requirement is quite huge, unless some expert here can solve it. You see: you are asking for a combination of numbers which sum up to 1000. Even if you have just 4 numbers, the various combinations possible from these 4 numbers is 15. And if you are talking about 100 such numbers, you could use the following formula to find the total number of possible combinations of these 100 numbers:
Sum (k=1 to n) of fact(n) / (fact(k) . fact(n-k)) where n = 100
Which will evaluate to 4087975 combinations.
And for each combination check if the sum is 1000.

- Mangesh