This is a great formula that I've never seen used before. I've always
predefined the entire range. Thanks for the help!

Brian

"Peo Sjoblom" wrote in message
...
Use a help column using you example starting in B2 after you insert a top
line and put a header in A1, then use this formula

=COUNTIF($A$2:A2,A2)<=1

copy down to B101 or to the last adjacent cell in A (you can move the
mouse to the lower right corner of the formula cell and when it changes
into a thin from a thick cross double click to copy down)

select both columns

do datafilterautofilter.

Depending on if you want to remove the duplicates or remove unique items,
assume you want to remove all duplicates, filter on B, select FALSE and
then select the visible area in A and B and do editdeleteentire row,
remove the filter and the help column

Voila!


--


Regards,


Peo Sjoblom






"leimst" wrote in message
...
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