better

well the first is easy , use countif() in column C....anything with 1 is a
match!
c1 := =COUNTIF(B:B,A1)
replicate down for all 200 in A

then it gets more difficult... you'd need to see what perms you have after
you strip out of B anything of value than the value in A that you're
checking
If you're down to 5 numbers out of a reduced list of 20, then you'll still
get almost 2 million combinations


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

I have got my head broken over this now....

What i need is...

I have two list of numbers... I need to compare these two list. Col A and
Col B.

Now, if Cell A1 value = any cell value in Col B then i need to shade both
the cells.

But if cell A1 is not equal to any cell in Col B then i need to add any
two
numbers in Col B which would be equal to cell A1 value.

If A1 value not matched then i need to add three values from col B and so
on. At max i would add five values of col B to get A1 value.

Same for A2,A3 .....

Hope this make the case clear...
Thanks!
Boss



"Patrick Molloy" wrote:

"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