1. Re-create the codes from 0-8000 in A2:A8001 in another
sheet (you can enter 1, 2, and then select them, grab the
fill handle, and drag down). Put "Remaining Codes" in A1.

2. In B2 on the same sheet, put:
=COUNTIF(Sheet2!A:A,A2)
This assumes your range of codes is on Sheet2, col. A.

3. Fill the formula down.

4. Filter for 0 or False on col. B using an AutoFilter
(Data Filter AutoFilter)

HTH
Jason
Atlanta, GA


-----Original Message-----
Hello.

I have a spreadsheet that is used to track unique
tracking codes assigned to
companies. I am looking for a way to easily identify
codes (within a range
of 0000-8000) that has not been assigned. I would
greatly appreciate help.

Thank you!
.