About 123,000 results
Open links in new tab
  1. Guidelines and examples of array formulas - Microsoft Support

    The following examples show you how to create multi-cell and single-cell array formulas. Where possible, we’ve included examples with some of the dynamic array functions, as well as …

  2. How to Use an Array Formula in Excel (+Examples)

    Aug 29, 2024 · What is an array formula? In simple words, an array formula in Excel allows you to perform multiple calculations on multiple cells in a range in one go. Its working is advanced as …

  3. Array formulas and functions in Excel - examples and guidelines

    Mar 22, 2023 · In this tutorial, you will learn what an Excel array formula is, how to enter it correctly in your worksheets, and how to use array constants and array functions.

  4. Array Formulas In Excel - Functions, How to Use? (Examples)

    Guide to Array Formulas in Excel. Here we use array formula, single & multi-cell, with MIN () & TRANSPOSE (), examples & downloadable template.

  5. Create array of numbers - Excel formula | Exceljet

    May 16, 2024 · To create an array of numbers like {1;2;3;4;5} you can use a formula based on the ROW and INDIRECT functions. This technique is most often used in array formulas that need …

  6. 4 Examples with Array Formula in Excel - Excel Insider

    Oct 19, 2025 · Learn 4 useful Excel array formula examples, including total marks, highest score, multi-criteria, and average of positive numbers.

  7. Array Formulas in Excel - Step by Step Tutorial

    This chapter helps you understand array formulas in Excel. Single cell array formulas perform multiple calculations in one cell.

  8. Create an array formula - Microsoft Support

    Create array formulas, often called Ctrl Shift Enter or CSE formulas, to perform calculations that generate single or multiple results.

  9. Dynamic Array Formulas in Excel - GeeksforGeeks

    Jul 2, 2025 · Dynamic arrays are resizable arrays that calculate automatically and return value into multiple cells based on a formula entered in a single cell. The new array (multiple cells) …

  10. All of Excel's Dynamic Array Functions - TheSpreadsheetGuru

    Feb 2, 2024 · A comprehensive list of all available Dynamic Array functions in Microsoft Excel