This is the second part of the advanced Excel series. The first part of the series can be accessed by clicking here. Array Formulas and Functions To convert the normal formulas to Array formulas, press ‘Ctrl+Shift+Enter. The formulas will be surrounded by Parantheses {}, which signifies that the it has been converted to an array…
14 Must-know Tips and Formulas from ‘Excel 2016: Advanced Formulas and Functions’ [Part 2]
Posted on