Finding Non-Duplicates

C

calibansfolly

I have a list of 53159 order numbers including dupes. There are
exactly three order numbers that only appear once. I need to track
down those three numbers. Any ideas?
 
B

Bob Phillips

Add a formula in a helper column of

=COUNTIF(A:A,A1)

Then filter this column on the value 1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
P

Peo Sjoblom

Make sure the list has a header, assume the list including header is
A1:A53160

in let's say H2 put

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


where A2 is the first cell with an order number


Now select A1:A53160, do data>filter>advanced filter, select copy to another
location and

put $I$1 there

in the criteria range put

$H$1:$H$2

H2 is where you put your formula


replace all cell references accordingly to fit your own data


then click OK
 
Top