View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
larry brunster larry brunster is offline
external usenet poster
 
Posts: 1
Default Finding missing values in a column

I'm looking for a way to automaticaly find missing values in a column of
numbers. Here's an example (all values are in the same column):

50
51
52
54
55

Value 53 is missing from the column (which should be increasing by 1 every
row). Is there a way to automatically detect that there is a gap between 2
values?

Thanks