<div class="raw-html-embed">    <p>The <b>FILTER</b> function is one of the <a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#lookupreference" onclick="onhyperlinkclick(this)">lookup and reference functions</a>. It is used to filter a range of data and to return the results that match the criteria you specify. The <b>FILTER</b> function only extracts the necessary data and the results update when the original data change.</p>

    <h5 class="pt8">Syntax</h5>
    <p><b><em>FILTER(array, include, [if_empty])</em></b></p>
    <p>The <b>FILTER</b> function has the following arguments:</p>
    <table style="width: 40%">
        <tbody>
            <tr>
                <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
                <th style="background-color: #f4f4f4"><b>Description</b></th>
            </tr>
            <tr>
                <td><b><em>array</em></b></td>
                <td>The range of cells to filter.</td>
            </tr>
            <tr>
                <td><b><em>include</em></b></td>
                <td>The filtering criteria supplied as a Boolean array (TRUE/FALSE) the same height (columns) and width (rows) as the array.</td>
            </tr>
            <tr>
                <td><b><em>if_empty</em></b></td>
                <td>The value to return when the filter returns no results. This argument is optional.</td>
            </tr>
        </tbody>
    </table>

    <h5 class="pt8">Notes</h5>
    <p>Please note that this is an array formula. To learn more, please read the <a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertArrayFormulas.aspx" onclick="onhyperlinkclick(this)">Insert array formulas</a> article.</p>
    <p><a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the <b>FILTER</b> function.</p>

    <h5 class="pt8">Examples</h5>
    <p>The figure below displays the result returned by the <b>FILTER</b> function.</p>
    <p><img alt="FILTER Function" src="https://static-helpcenter.teamlab.info/filter_4db4539712.png"></p></div>

FILTER Function

Docs

Argument	Description
*array*	The range of cells to filter.
*include*	The filtering criteria supplied as a Boolean array (TRUE/FALSE) the same height (columns) and width (rows) as the array.
*if_empty*	The value to return when the filter returns no results. This argument is optional.

FILTER Function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud