some only occur once and these are the ones that I want to work with

One thought - try autofiltering on a helper col
Assume data in A2 down
Put in B2: =COUNTIF(A:A,A2)
Copy down. Put a label in B1. Then do a datafilterautofilter on col B,
choose: 1, to filter out the required lines. You can copy the filtered lines
and paste it elsewhere.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---
"Karen" wrote:
I have numerous lists of about 2500 numbers each where most occure twice, but
some only occur once and these are the ones that I want to work with. Any
suggestion as to how I can do this in a simple manner?