Hi,
you have your number in column A, in column B enter the complete list of
numbers then in column C enter

=IF(COUNTIF(A$1:A$5,B$1:B$100)=1,"",B1)

copy down

change range to fit your needs

"Nancy" wrote:

I have items that have been assigned an ID number. How can I extract a list
of unassigned numbers? I.E. I have number range starting with
7200000-7232000. How can I extract a list of unassigned numbers from this
list of numbers? I know some of the Excel functions but I could not figure
this out.
--
nfw