Create an Array Formula in Excel

An Array formula is a way to applying the formula It started with curly bracket. Array formulas are very powerful formulas that enable you to perform calculations you can’t do with standard worksheet functions. Excel provides two types of array formulas: Array formulas that perform several calculations to generate a single result and array formulas that calculate multiple results. Some worksheet functions return arrays of values, or require an array of values as an argument.