3305 Main Street Ste 019 Vancouver, WA 98663

Helper Functions

Helper functions are often used in conjunction with other functions (or queries), these functions make certain tasks easier.

Function Description
LRFilter The LRFilter function is useful to work around the maximum forumla length limit of Excel by allowing you to break a single formula into smaller pieces. The LRFilter function was originally created to address Liberty Reports formulas with complex filter arguments, but it can be used for any text argument in any Excel formula.
LRKeep The LRKeep function keeps the values in a data entry column on the correct rows when the adjacent query is refreshed, while also enabling adjacent formulas to fill down.