OR......copy the 359 and paste them below 1122...keep a row's gap so that
you know where they start from because you will delete them later. now
select the column go to FilterAdvance Filtercheck COPY TO ANOTHER LOCATION
box and check UNIQUE RECORDS ONLY box. choose your range. Once you have the
unique ones...delete the ones you pasted in the first step.

does it help?

"sam" wrote in message
...
Good morning -

Have searched this and can't quite figure it out.

I have a column containing 1122 numbers. They are unique numbers.

I have another column that contains 359 of those 1122 numbers. How can I
determine which are the remaining 763 numbers. In other words, " not equal
to" the 359 numbers.

Auto filter won't work; I can't copy in the 359 numbers after using the
"Does Not Equal" filter in the Custom box from the Drop-down Autofilter
menu.

I am stumped! Thanks to anyone who takes the time to answer. I'll keep a
close eye on this post for responses.

sam