From: billnock on
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.
From: Gary''s Student on
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.