View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bman342 bman342 is offline
external usenet poster
 
Posts: 22
Default Function for missing data in a series?

I am collecting a series of data labelled numerically from 1-1000. I need to
determine which in the series are missing. ie I know I have 750 data elements
out of 1000, so I know there are 250 missing. But I need to detmine which
specific data elements are missing.

Is there a function, or routine to automate this?

Thx!