Move and Group duplicate data into a table on same sheet?

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

Hi

Try this

Please Login or Register  to view this content.

rylo

Thanks! I ended up using a vlookup over the weekend before I saw you reply.