Filter a list for missing numbers
 

I have a rather long (2000) list of stamp numbers, and want to filter out and
print a list of those ( from 1 to 2000) that are misssing..a "want list".
Tried some options but didn't get anywhere. Thank you. Excel 2003 on Vista.

Filter a list for missing numbers
 

Say your list of numbers is in column A. In B1, enter:

=IF(COUNTIF(A:A,ROW())=0,"Item " & ROW() & " is missing","")
and copy down
--
Gary''s Student - gsnu201001


"billnock" wrote:

I have a rather long (2000) list of stamp numbers, and want to filter out and
print a list of those ( from 1 to 2000) that are misssing..a "want list".
Tried some options but didn't get anywhere. Thank you. Excel 2003 on Vista.

Filter a list for missing numbers
 

What didn't work with this earlier idea given to you (~10 days ago):
http://tinyurl.com/ychmxzj
Engage the responder who would have QC'ed the idea before posting it
--
Max
Singapore
---
"billnock" wrote:
I have a rather long (2000) list of stamp numbers, and want to filter out and
print a list of those ( from 1 to 2000) that are misssing..a "want list".
Tried some options but didn't get anywhere. Thank you. Excel 2003 on Vista.