To filter out the data, you simply need to click on 'Data | Create a filter'
View attachment 5856
Once you have active the filter, you simply need to click on the upside-down triangle icon View attachment 5859 from any of the columns that you want to filter on and add your own condition.
For example to filter on TX dealers only, simply click on the upside-down triangle of the SOLD_TO column, and write down the following condition:
View attachment 5857
You can put as many filter condition as you want. To reset your filter condition you just need to click on 'Data | Turn off filter':
View attachment 5860
Hi @Michelw
You have these options as the sheet owner. But it looks like the protections on the sheet don't allow viewers to make these filters. Here's what I see:

It looks like there's not a "Create a filter..." option as read only?