If you are working on a data range, and want to convert the range into a data table, please check how to convert data into a table. Once you have the table, please see steps below to filter a table:
Step 1: In the Table, click the small triangle right after the column name in the top row (e.g., first column);
Step 2: In the drop down window, select a value (or values) from the list;
Step 3: For example, select value 2 and 3 from the list;
Step 4: The table with the selected values will be created, other rows are filtered out.
