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!