How do I compare tow columns of numbers?

[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.

[mrice]

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

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

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