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.

Gary''s Student

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question