Filters in Google Sheets let you analyze data in your document by showing only the things you want. However, it changes how others see the document, too. Here’s how to use filter views to leave each collaborator’s view unchanged.
Fire up Google Sheets and open up a spreadsheet to get started.
Click Data > Filter Views > Create New Filter View.
For this guide, we want to filter anything in the table that has a price per unit greater than $10. Click the filter icon in the field for “Price Per Unit.”
Read the remaining 21 paragraphs
Source : Filter Google Sheets Data without Changing What Collaborators See
