How do I filter rows based on multiple ranges of values in a single column?

[Tyrandrewsaur]

I currently have a very very very large spreadsheet (with over 5000 rows) that I need to filter out specific numbers and number ranges based on a single column. The data looks basically like this
Office Calc Help Pls.ods (9.9 KB)
This is a very small version of the main file but it gets the point across.

Essentially I need to filter out rows that don’t have column C “cart number” (If you wanna know what a cart number is see the block quote below) with the numbers 35, 300 through 500, 1033 through 4000, 7075, 9001, and 9300 through 1300 (these are not the real numbers I need as I don’t know them off the top of my head but this yet again gets the idea across).

Cart numbers are unique ID’s given to audio files so that our audio system knows which specific file to play, they are duplicated here because this file is a list of all that have played which all of those cart numbers play multiple times throughout a day, month, or year

I have been researching macros and the filter system for a few days now and have not quite found out how to accomplish the task I need to. Basically I want to know if there is a way, and if so how or at least where to start looking to make it work. Here is my issue.

So far I have looked into the filter system and also macros but the filter system so far while playing with it for a while can’t accomplish my task without being an advanced filter and I can’t figure out how they work and I can not find any macros to do this task since it is so specific.

[erAck]

You can use either Data → More Filters → Standard Filter… to define multiple criteria and ranges, which for a bunch of ranges can be quite tedious, or you set up an Advanced Filter where you can easily define and modify filter criteria in a range of spreadsheet cells and then with the data range selected (or just the cell cursor in the contiguous data range, it will get selected automatically) go to Data → More Filters → Advanced Filter… and input the cell range for Read Filter Criteria From.

Note this creates an anonymous database range to remember the filter settings, to refresh the data range change the criteria in the cell range and use Data → Refresh Range. A more complete setup is to first define a database range for the data with Data → Define Range… (e.g. DataRange) and create a named range for the filter criteria cell range with Sheet → Named Ranges and Expressions → Define… (e.g. FilterCriteria) and under Range Options mark it as Filter so it can be selected in the Advanced Filter’s criteria list. That way you can easily switch between different criteria sets using different cell ranges.

I’m attaching your sample file with such filter set up according to your example given.
69029-ask-Advanced-Filter.ods (9.8 KB)

[Tyrandrewsaur]

Okay, I see how that works now. Advanced filters are just an easier and quicker way to use the standard filter. So instead of using all the drop downs with the and/or and inputting your criteria you can just list it out and also allow for the “between” statements. So when we input the less than and the greater that statements in columns next to each other, it will read it as a between statement and not just filter out all the data.

Thanks so much for the help!!! I now understand enough to be able to utilize advanced filters later.