Advanced Filter with duplicate deletions

[Bob Phillips]

hi....how could I do this but not delete the rows, but either sort by them, so all duplicates & orginials are at the top? Alternatively, how could I copy just the duplicates , once identified, into a new worksheet?

Add a helper column with a formula

=IF(COUNTIF(A:A,A1)>1,"Dup","")

and then just sort by the helper column