How do I compare tow columns of numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
comparing 2 columns 6
combine two numbers -- not add 7
compare 2 columns of numbers and place the matched numbers in a 3r 5
compare two columns and pull out differences 1
List Comparison 3
Exact Function 1
Conditional SUBTOTAL in XL210 Table 7

Back
Top