How do I compare tow columns of numbers?
 

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.

How do I compare tow columns of numbers?
 

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.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=551527