View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
billnock billnock is offline
external usenet poster
 
Posts: 3
Default filter for missing values in a range

I have a list in Col A ( about 2000) one to four digit numbers. I would like
to ( for example) , in the 700's be able to filter and find out which of the
numbers from 700 to 799 is NOT in the list. I know how to copy and paste
to another col, etc.
Thanks in advance for the wonderful help all of you give.