View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Sam is offline
external usenet poster
 
Posts: 699
Default Extract "Does not equal" data

Good morning €“

Have searched this and cant 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 wont work; I cant 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. Ill keep a
close eye on this post for responses.

sam