OK, so wil lcolumn a have all numbers and colum B have a subset, or will each
have numbers the other doesn't?

to remove the duplicates, You can use Advanced filter:

Data filter Advanced Filter

Select Column A as your List Range, copy to another location, E1 with unique
records only.

Same for column B to the bottom of your new E list.

Then, do one more advanced filter to drop the numbers into C and D as unique.

"Chi" wrote:

Hi Luke and Sean,

Sorry, It isn't the same list of numbers in each column. Moreover, some
numbers on column A and B are duplicates.

Would you please show me how to use MATCH or INDEX function?


"Luke M" wrote:

If it's the same list of numbers in each column (as in your example) you can
sort each columns seperately.

If that's not what you're looking for, you might want to take a look at the
MATCH or INDEX functions.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Chi" wrote:

Hi,

I have two columns- A and B- store numbers. Is there a way I can match the
numbers so that the numbers on column A will be the same numbers on the
column B?

Ex: ColumnA ColumnB
100 105
106 103
105 106
103 100

I would like them look like this: Column A Column B
100 100
103 103
105 105
106 106

Thank you
Chi