How do I compare tow columns of numbers?

K

ken0860

I want to compare two columns of numbers to see if any combination of numbers
in column A equals any combination of numbers in column B.
 
M

mrice

That's a lot of possible combinations so a long running macro will b
needed.

You could try to generate all the combinations in each by using th
binary representation of the two to the power or the number of items i
the column as a key to show which items to try together.

If you then loop through the combinations between the two columns, yo
can list the matches as they occur somewhere else on the sheet
 
Top