How to delete rows from a given list

[dmb41]

I have a lot of data with parts in each row, like the following:

P101 9 2 1 . . .
P102 8 9 0 ......
P103 ....
P104 ....
P105 ....
P106 ....
P107 ....

How could I eliminate (delete) just the following in the above:
P103
P104
P107

I have about 500 that I want to delete thats why I don't want to do it manually.

 

[JackDanIce]

Can you explain the logic behind which rows you want to delete? Your example is not clear enough to understand

 

[pbornemeier]

Use a filter to show the rows you want to delete.
Use Goto (F5) | Special | Visible Cells Only
Delete Entire Row

 

[dmb41]

JackDanIce - The rows I want to delete would be a given list of parts (P101,P102, etc) out of the given list. There is no logic to the order just parts I want to delete from the list. (There is a list I have (about 500) and the list I want to delete from contains 1000 +).

Hope this helps.

 

[JackDanIce]

I would use a MATCH function in a column to the right of your main list against your parts-to-delete list. Any formula that brings back a match is what you want to delete, so you can then re-order your main list and delete all those rows out in a single go

 

[dmb41]

Thanks!