Say we start with:

115
109
105
111
112
117
114
104
106
102
107
100
101
116
118
110
113
103
119

First we sort them:

100
101
102
103
104
105
106
107
109
110
111
112
113
114
115
116
117
118
119


Then in B2 enter:

=IF(A2-A1=1,"",A2-A1-1) and copy down. We now see:

100
101
102
103
104
105
106
107
109 1
110
111
112
113
114
115
116
117
118
119

This identifies 108 as the missing value.
--
Gary''s Student - gsnu200901


"Nancy" wrote:

I have a large item master list and would like to find numbers that have not
been assigned. Is there a simple formula I can use to pull out numbers not
used in a string on numbers?
--
nfw