Prev: Seperate text and numbers in a column?
Next: Right click and see font details
From: billnock on 10 Feb 2010 07:59
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 10 Feb 2010 08:21
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.
 | 
Pages: 1
Prev: Seperate text and numbers in a column?
Next: Right click and see font details