Hi
Several possible solutions. In ascending order of actions to perform:
1- Data
Filter
AutoFilter
(see help)
One of the features is Show only the current item, but we must open the drop-down list to access it.
2- Create a database connected to the spreadsheet. Register this database (Tools
Options
Base
Databases
).
Such a database can be opened in the View
Datasources
(F4) . The toolbar contains filter tools including AutoFilter.
3- Data
Filter
Advanced filter
You can use Data
Validity
to generate a listbox of tags (see B3 in bugs.ods)
and use it in an advanced filter :
- Open bug.ods
- Select e.g. Calc in the listbox (B3)
- Click anywhere in the range A8:F18, then
Data
Refresh Range
, the results are updated in B23
Regards