Forum Discussion
Using the FILTER function to filter out data
- Nov 01, 2024
BobbyBGud So by the 'filter button' I'm talking about the button on the right of this image:
so click on the table you want to filter and then make sure that button is highlighted as in this image
This will add drop down menus to each column as shown on the first row in this image:
Also in this image I clicked on the drop down in column C (Device) and you can see the options.
at the bottom (cut off on this image) is a list of all values in that column where you can unselect items you don't want to show.
You can also see the option for "Text Filters" and then a submenu of various options will appear for that method (e.g. Text value contains...)
I attached a sample to see if it will address your question.
Do let me know if further clarification is required.
Cheers