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:

Sub wyanrandy()

Dim rcell As Range
Dim lr As Long

Application.ScreenUpdating = False

lr = Cells(Rows.Count, 1).End(xlUp).Row

Range("E2:E" & lr).AutoFilter Field:=1, Criteria1:="=O", Operator:=xlOr, Criteria2:="=T"
Range("B2:B" & lr).SpecialCells(xlCellTypeVisible).Copy
Range("L1").PasteSpecial Transpose:=True

ActiveSheet.AutoFilterMode = False

lr = Cells(Rows.Count, 2).End(xlUp).Row

Range("L1").Select

Do Until ActiveCell.Value = ""
    
    For Each rcell In Range("B2:B" & lr)
    
        If rcell.Value = ActiveCell.Value Then
        
            rcell.EntireRow.Delete shift:=xlUp
            
        End If
        
    Next rcell
    
    Range("L1").Delete shift:=xlToLeft
    
    Range("L1").Select
    
Loop

Application.ScreenUpdating = True

End Sub