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)

"calibansfolly" wrote in message
ups.com...
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?