View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Nancy Nancy is offline
external usenet poster
 
Posts: 41
Default How can I extract a list of numbers missing in a list?

I have items that have been assigned an ID number. How can I extract a list
of unassigned numbers? I.E. I have number range starting with
7200000-7232000. How can I extract a list of unassigned numbers from this
list of numbers? I know some of the Excel functions but I could not figure
this out.
--
nfw