Copy the following formula down for each number you want to check.
The
formula will return 1 for each number not used in the string of
numbers. I'm assuming that the 'string' of numbers are in one cell.

You can then use AutoFilter to extract these numbers.


=IF(ISERROR(FIND(E10,$E$4)),1,"")
=IF(ISERROR(FIND(string_to_search_for,string_to_se arch_in)),1,"")


More FREE Excel Tips at...
http://www.TheExcelAddict.com