| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I extract a list of numbers missing in a list? | New Users to Excel | |||
| Identify missing numbers in list | Excel Worksheet Functions | |||
| Find missing numbers in a list | Excel Discussion (Misc queries) | |||
| Find Missing Numbers in a List | Excel Discussion (Misc queries) | |||
| MISSING NUMBERS IN LIST | Excel Discussion (Misc queries) | |||
Linear Mode
