Hello, I would like to be able to have excel search a column of data for duplicates and then move those duplicates into a seperate table. Thanks in advance for you help.

For example:
Column A
123
222
456
123
778
222


New table would have:
123
222