How to display rows in excel when cell value is less than 30?

Question

excel

there is a table, for example with vegetables
| fruit | expiration date | grade
| apple | 30 | grade 1
| orange | 45 | grade 1
tangerine | 23 | grade 2
apple | 33 | grade 1
shelf life", less than 30

Answer 1

1. Stupidly copy the table (if necessary, because the operation is reversible, all data is saved), add an autofilter, put the filter "less than 30" in the "expiration date" column, voila
2. If you need to update regularly, you can do it through pivot tables (pivot), and if necessary, update the data after changing the source table
As an option, make a slicer, and use the handles in it to select the dates that are needed. The table will be filtered accordingly.
3. You can make buttons and VBA, if you have a soul for this, but IMHO autofilters are the easiest and probably most convenient.