Sort and Elimination Help

[semperfi360]

Okay here we go.

I want to be able to specify certain machine numbers whose records (rows) I want to keep. All other machines that do not match these couple of machine numbers, I want deleted.

What would be required to do this? An advanced sort?

Ive attached a simple excel sheet as an example. Let us say I want to keep the records for the 1108, 1118, and 2201. All other machine rows should be deleted.

[martindwilson]

if its only a couple use auto filter/custom does not = 1118 "and" does not =1108
then delete the filtered rows
if its more than 2 then use advanced filter as attached
or do as in the alternative put your list in say column h then in e2 dragged down put

=IF(ISNUMBER(MATCH(A2,$H$1:$H$16,0)),1,"")
sort the lot by col E all the ones you want will be at the top

[semperfi360]

That is exactly what I was looking for! The advanced filtering works the best for me.
Thanks!