View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
petermcwerner petermcwerner is offline
external usenet poster
 
Posts: 4
Default Find missing values in a series

I have a column with transaction numbers which are non unique values, but
some values are missing

1
1
2
2
2
4
4
5
5
6
6
6
8
8
.....
10000

I want to output a list of the missing values:
3
7
.....