Hi,

I have a single column of numeric data that I want to search for duplicates.
I know that I can use a "countif" statement with Conditional Formatting to
highlight all the duplicates (e.g. ="COUNTIF(A$1:A$100, A1)1") but then is
there a way to remove all of the remaining unique numbers or maybe using
some sort of megaformula copy the highlighted cells along with any other
data in that particular row to another spreadsheet?

Thanks,

Brian