Ask Your Question

how can I create a manual filter in calc?

asked 2019-01-04 07:39:28 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-01-04 18:06:28 +0100

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 realfilter. Here is the topic with example spreadsheet - 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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-04 07:39:28 +0100

Seen: 26 times

Last updated: Jan 04