filter out the duplicates

  • Thread starter Thread starter A Davis
  • Start date Start date
A

A Davis

I would like for excel to look at column A and filter out the
duplicates. ( not advance filter, Unique records) WHAT I mean is to
take ALL OF the alike cells and move them to B. not leaving any of
What was a duplicate , before formula was run, in A.
Thanks!!!!
 
I'd use a formula like:

=if(countif($a$1:$a$999,a1)>1,a1,"")

and drag down

If I wanted the list moved somewhere else, I'd copy|paste special|Values, and
maybe sort that resulting list.

(You're keeping just the values that appear more than once (and you're keeping
all of the entries--uniques are the only things gone?)
 
Back
Top