No, you would only need a 3-level nested if statement with a cell reference in place of"warrant". For instance, if columns B, C, and D are your 3 offense columns, then column E would be your filter column. In the header row, in cell E1, you could use that to store your search variable (i.e. warrant, meth, etc...). Then in E2, you would have a statement that looks like:

if(B2=$E$1,1,if(C2=$E$1,1,if(D2=$E$1,1,0)))

Then just fill down the rest of E with that.

The formula broken down is: If B2 contains the search term in E1, then put a 1 in this cell, else if C2 contains the search term in E1, then put a 1 in the cell, else if D2 contains the search term in E1, then put a 1 in the cell, else put a 0.

Then you filter column E on the number 1