Use another column, filled with a formula like this:

=COUNTIF(A:A,A2)

then sort you whole sheet based on that column, descending to get the dupes
at the top, ascending to get the dupes at the bottom.

HTH,
Bernie
MS Excel MVP


" wrote in message
...
I have column with that I am using cond form to check for dups.
Is there a way to sort the column asceding or descending were the non-dups
will
to the top or bottom of the col
not very familiar with the adv auto filter