Yahoo Italia Ricerca nel Web

Entra

Risultati di ricerca

  1. support.microsoft.com › en-us › officeFILTER function - Microsoft Support

    How to use the FILTER function in Excel to filter a range of data based on criteria you define.

  2. Video

    Mostra tutto

  3. exceljet.net › functions › filter-functionExcel FILTER function | Exceljet

    The Excel FILTER function is used to extract matching values from data based on one or more conditions. The output from FILTER is dynamic. If source data or criteria change, FILTER will return a new set of results.

  4. www.ablebits.com › office-addins-blog › excel-filter-functionExcel FILTER function - dynamic filtering with formulas -...

    12 apr 2023 · The FILTER function in Excel is used to filter a range of data based on the criteria that you specify. The function belongs to the category of Dynamic Arrays functions. The result is an array of values that automatically spills into a range of cells, starting from the cell where you enter a formula. The syntax of the FILTER function is as follows:

    • Svetlana Cheusheva

  5. exceloffthegrid.com › filter-function-in-excelFILTER function in Excel (How to + 8 Examples) - Excel Off The...

    27 gen 2023 · This post shows how to use and master the FILTER function in Excel. FILTER is a power dynamic array function which you need to know.

    • excel filter function1
    • excel filter function2
    • excel filter function3
    • excel filter function4

  6. www.spreadsheetclass.com › excel-filter-functionUsing the FILTER function in Excel (Single or multiple...

    The FILTER function in Excel allows you to filter a range of data by a specified condition, so that a new set of data will be displayed which only shows the rows/columns from the original data set that meets the criteria/condition set in the formula.

  7. www.howtogeek.com › 855033 › filter-function-excelHow to Use the FILTER Function in Microsoft Excel

    10 gen 2023 · What Is the FILTER Function in Excel? The syntax for the formula is. FILTER( array, range=criteria, if_empty) where only the first two arguments are required. You can use a cell reference, number, or text in quotes for the criteria, depending on your data.