How to filter a list to show records that are NOT duplicated

[anewc1]

Each number should show up twice, and if it only shows up once, those are the ones I want to find. For instance, in the list below, 2054, 3001 and 3168 only show up once. The list is several hundred thousand lines long, so I can't do it by hand. Thanks for any help!

Personnel No.
376
376
411
411
2052
2052
2053
2053
2054
2058
2058
3001
3168
3192
3192
3196
3196

 

[iggydarsa]

1- are they always sorted like in your example?
2a- can there be 3 or more repeated value?
2b- If there are 3 times repeated value, do you still wanna see it in the list?

One approach could be creating a macro and when you run that it can highlight the stand alone ones...

 

[anewc1]

Now's about the time when I wish I could delete posts.

All I had to do is do a simple countif for the Emp# and then do an autofilter for the ones that had a count of 1 versus 2.

Oops.

 

[jim may]

I put your listing in Cells A1:A17

In Cell B2 I entered =OR(A2=A1,A2=A3) and Copied it down to B17

All cells containing FALSE are your Unique (Single) Numbers

 

[anewc1]

Thank you both for your help!