Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare data from 2 columns | Excel Worksheet Functions | |||
using functions to compare multiple columns for mismatch of cells | Excel Worksheet Functions | |||
Compare text/numbers in different columns. | Excel Discussion (Misc queries) | |||
how to compare 6 columns of text data | Excel Worksheet Functions | |||
using VLOOKUP to compare 2 columns to find new information | Excel Worksheet Functions |