Hi guys,

So basically I have a formula that is counting non-empty cells in a certain column of my table. Is it possible to then filter my table based on the findings of this formula? Furthermore would it be possible to actually click on the result of the formula and then being transfered to the sheet where the table is located and having the table filtered to only show the cells that corresponds to the count of the formul?

My table has the columns (located in another sheet and source data called "KS")

File l Code


So I make a countifs formula and find the cells corresponding to a File = "Budget" and that in the code includes "AD"

=COUNTIFS(KS[File];"Budget";KS[Code];"*AD*")

Now I would like to click the result and get my table to be filtered according to this result.


Thanks in advance.