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