Excel

Question

I have two columns with numbers. In both columns some are duplicates, some numbers are not duplicates. How do I write a formula that finds the duplicates and confirms they're in the column, then also insert the non duplicates into one of the columns in numeric order?