What is an Array Formula?
The Array formulas are most powerful formula in Excel. An array formula is a formula that works with an array and replaces thousands of other formulas in a single array formula to get result in a single cell using SUM, AVERAGE and COUNT function. Also it know as “CSE” formula the magic of three keys {Ctrl+Shift+ Enter} [Array Means a group of things (values, text, TRUE/FALSE) stored in a range of cells or in memory]
Rules for Array Formula:-
There are four important points for array formula in Microsoft Excel it is important to know 4 fundamental rules.
(i) An Array formula must have the same amount of rows and columns within in each argument
(ii) While you are entering an array formula you must hold Ctrl+Shift+Enter then you will get the result, if you hit Enter it will evaluate a "VALUE!" error.
(iii) You Can’t Add the { } (Braces) that surround an array formula yourself, it will add automatically by Holding Ctrl+Shift+Enter.
(iv) You Can’t Use an Array Formula on an Entire Column in a spread sheet.
Example:-
The Array formulas are most powerful formula in Excel. An array formula is a formula that works with an array and replaces thousands of other formulas in a single array formula to get result in a single cell using SUM, AVERAGE and COUNT function. Also it know as “CSE” formula the magic of three keys {Ctrl+Shift+ Enter} [Array Means a group of things (values, text, TRUE/FALSE) stored in a range of cells or in memory]
Rules for Array Formula:-
There are four important points for array formula in Microsoft Excel it is important to know 4 fundamental rules.
(i) An Array formula must have the same amount of rows and columns within in each argument
(ii) While you are entering an array formula you must hold Ctrl+Shift+Enter then you will get the result, if you hit Enter it will evaluate a "VALUE!" error.
(iii) You Can’t Add the { } (Braces) that surround an array formula yourself, it will add automatically by Holding Ctrl+Shift+Enter.
(iv) You Can’t Use an Array Formula on an Entire Column in a spread sheet.
Example:-