Thread: Combinations
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default Combinations

"please help" doesn't work - thats what everybody ALWAYS does.

even 5 out of 200 is HUGE ie 304,278,004,800 permutaions

what is it exactly that you're trying to achieve? Please give us everything.
... adding a second column was the first surprise


"Boss" wrote in message
...
Thanks for the reply...

Actually i need to add five or less numbers which are in column A to any
number in column B.

Column A has 200 numbers And column B has about 50 numbers


Col A Col B
256 490
234
325
214
256
147

In the example 256+234 = 490

Please help.
thanks!
Boss


"Mike H" wrote:

Hi,

This isn't clear, you want all possible conbinations of 200 numbers but
how
may do you want in each number set? what do you want them to add up to?

Mike

"Boss" wrote:

Hi,

I have about 200 numbers in a column. I need to find all the possible
additions which are possible using those numbers. My final aim is to
match
the answers with some other data.

I did a lot of search in google but failed. please help.

Thanks!
Boss