SheetXL - v0.8.0-beta.9+sites.210.e2d420901
    Preparing search index...

    Interface GetRankedOptions

    Options for finding top values in a range.

    interface GetRankedOptions {
        compareFn?: (a: Scalar, b: Scalar) => number;
        distinct?: boolean;
        filterFn?: (v: Scalar) => boolean;
        includeBlanks?: boolean;
        limit?: number;
        reverse?: boolean;
    }
    Index
    compareFn? distinct? filterFn? includeBlanks? limit? reverse?
    compareFn?: (a: Scalar, b: Scalar) => number

    Custom comparison used for ordering results (e.g. for UI display).

    Internal default comparison
    distinct?: boolean

    If true duplicate values collapse to a single entry.

    false

    filterFn?: (v: Scalar) => boolean

    Optionally restricts the population (e.g. numbers only).

    includeBlanks?: boolean

    If true blank will be considered when ordering.

    false

    limit?: number

    Maximum number of values to return.

    10

    reverse?: boolean

    If true the ordering is reversed (lowest values first).

    false

    Settings
    Member Visibility

    On This Page
    Properties