Inspreadsheetprograms, an array is arangeor series of related datavaluesthat are usually in adjacent cells in a worksheet.
These instructions apply to Excel 2019, 2016, 2013, 2010, and Excel for Microsoft 365.
What Are Array Formulas?
Array formulas are similar to regular ones.
For this reason, an array formula is sometimes called aCSEformulain Excel.
Any time you edit an array formula, the curly braces disappear.
To get them back, press theCtrl,Shift, andEnterkeys again.
Hold down theCtrlandShiftkeys on the keyboard.
Press and release theEnterkey to create the array formula.
If done correctly, curly braces will surround the formula.
Therefore, each one produces different results.
(TheTRANSPOSEfunction copies data from a row into a column or vice versa.)
Here, the largest value represents the slowest time.
