I need to make a manual filter with 2 source column named “companies and products” that keep mixed data and 2 goal column that in first one i shod select my company name and in the second list i should have a dynamic list that make able me to see list of that company products… can you explain me how can i make it? tnx
You can create a “based on formulas filter”, which will display only some matched values based on predefined test condition, but it will not be a real filter. Here is the topic with example spreadsheet - [Tutorial] Sorting and Filtering data with formulas (View topic) • Apache OpenOffice Community Forum Also please find a sample file which is edited based on your needs. But I still insist, that you should better use Calc built-in filtering functionality, Auto Filter will be a nice solution or consider working with database.