I came across this function in one of my worksheets and wanted to know what the curly braces are used for.
Here is an example.
{=array(sheet1!a1,sheet2!a3,sheet2!a5,sheet2!a6)}
They are used in Array Formulas
.
Excel surrounds the formula with braces ({ }) and places an
instance of the formula in each cell of the selected range.