Match multiple columns with different values to make a master list of both

I'm looking to match 2 columns to generate a master list, which will show matched and unmatched (in column A not in B, and also column B not in A).

See the example spreadsheet

With a macro (using the NoDups function)

Thanks...perfect...:-)

Thanks, this works for these numbers, but what if my lists were

10001
10010
10082
10090

&

10009
10010
10080
10100
10101

Should be
10001
10010 10010
10080
10082
10090
10100
10101

I wouldn't necessarily want 10000 blanks before the 1st number?
Could this be changed just to use the numbers given?

Thanks

Thanks...if the original columns were D&E and outputting to m&n, how would the macro change?

Also, what if columns A & B were on different sheets within the current spreadsheet...say Column A on sheet1 and Column B on sheet2??

Thanks again

Originally Posted by Niper

...if the original columns were D&E and outputting to m&n, how would the macro change?..

Find these lines in the code

Please Login or Register  to view this content.

If columns A and B are on different sheets then it will be easier to copy them onto one sheet.