Advanced filter?

http://www.contextures.com/xladvfilter02.html#List

You should of course change the formula since you don't want to include
items from the invalid list

=COUNTIF(cell,list)=0


--
Regards,

Peo Sjoblom



"Eliminate invalid information" <Eliminate invalid
wrote in message
...
I have two spreadsheets: the main list has all information and another with
the invalid information. I want to create another spreadsheet that will
eliminate all the invalid information on the second list from the main
list
to create a new main list2.