Sense Excel, the Add-In for Microsoft

If you miss something please send us an email. Thanks!

<< Back to all topics
You are here:


SenseFilter is a function that allows the use of two parameters. It can be used as a filter box and allows the use of curtain wildcard characters such as ” * “.

The first parameter can be a fieldname (e.g. Year) in double quotation marks (“), is delimited by a semicolon (;) and followed by the second parameter (e.g. 2019), which is the filter to be used (without quotation marks). The syntax is as follows: =SenseFilter(“[Fiscal Year]”; 2019)

=SenseFilter("[Fiscal Year]"; 2019)

This function is added to any empty cell within Excel and causes the imported tables and their associated field names to be filtered by a second parameter. The Cell with the Filter will state “Already Filtering”.

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
Please Share Your Feedback
How Can We Improve This Article?
Need help?
No Comments

Post a Comment