A filter is useful when preparing your data. After creating a filter, not only you can use the filter to sort the data, but you can also filter the data based on certain criteria. Please see below for details:
Step 1: Open the sheet with the filter and click the filter button in the column (e.g., column A). Please check here to create a filter if not yet;
Step 2: The default window is to "Filter by values". To see the data for one or more values, select the values from the value list;
Step 3: Click "OK" at the bottom, and only the data you selected will display;
Step 4: You can filter the data by the condition by clicking "Filter by condition" from the drop-down list;
Step 5: In the box, select the condition rule in the first box (e.g., "Text contains"), and type the value in the second box (e.g., "Jack");
Step 6: Only the rows with the value (e.g., "Jack") will display.
