Reference
No results for 'undefined'
    Powered by Algolia

    FILTER_IN_SET

    Returns a filtered version of the source frame, returning only rows that are included in the set.

    Syntax

    =FILTER_IN_SET(inputFrame, inputFrameColumn, filterFrame, [filterFrameColumn])

    Parameters

    1. inputFrame
      • Type: Frame
      • Description: The data to be filtered.
    2. inputFrameColumn
      • Type: String
      • Description: Column name to use as test element in set.
    3. filterFrame
      • Type: Frame
      • Description: The set that should filtered data should be in.
    4. filterFrameColumn [optional]
      • Type: String
      • Description: Column name to use to form set of elements to check against.

    Returns

    • Type: Any
    • Description: Returns value or frame extracted by EL pattern

    Example

    =FILTER_IN_SET(A1, "field", B2, "field")

    Try It Now

    Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.
    Contents