Remove multiple rows based on multiple cell's criteria

I'm looking for an idea on how to make something like this work:

Column B has a ID number it could have multiple of the same number ex: 1234 in cells B2, B3, B4 etc. At anytime there's upwards of 60,000 ID numbers not all unique.

Column E has the type of document it would be, O, T, C, I

I'm looking to show only ID #'s that do not have a O, or T, so if ID # 1234 has 7 document types (7 IDs in column B) if anywhere in column E there's a O or a T I'd like to remove all those ID #'s.

I'm having trouble figuring out a formula/vba code to remove the rows based on the criteria mentioned above.

Any help or ideas would be appreciated. Thanks!

id num.xlsx

here is basic idea of the file

You can Autofilter on the sheet. In Column E Custom Does Not Equal O and Does Not Equal T. Then Filter Column B for the ID number.

I'm not entirely sure I'm on the same page as you. I tried using the filter and showing cells that are not O or T. The problem is, if there's 7 of the same ID and one of those are O or T then I need it to remove all of that ID not just the O or T row. Unless we're talking about a different filter?

Maybe:

Please Login or Register  to view this content.