Hide Rows Automatically

Hello

One way if you're happy to use VBA, then the following code on a Button click would hide all rows in the specified range where column F as an 'x':

Sub Button1_Click()
Dim c As Range

For Each c In Range("F2:F20")
    If c.Value = "x" Then
        Rows(c.Row & ":" & c.Row).EntireRow.Hidden = True
    End If
Next c

End Sub