Thread
:
Find missing values in a series
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
petermcwerner
external usenet poster
Posts: 4
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
.....
Reply With Quote
petermcwerner
View Public Profile
Find all posts by petermcwerner