Non-macro solution:
1) J3 = "Key"
2) J4 =COUNTA(E4:I4)
3) Copy cell J4 down the whole data set
4) Click Data > Filter > Autofilter to turn on the AutoFilter for this data
5) Click J3 drop down and select Custom
6) Is greater than 0
Now all the rows that don't match are hidden. No VBA needed.
Bookmarks