Array Formulas.
Entering an Array Formula.
Array formulas are formulas which return a set (an
array) of values and are usually entered into a range of cells. Any Excel
formula can be entered as an array; some functions require that they are
entered as arrays in order to return meaningful results.
Some array formulas are entered into a single cell;
this is where the cells that they are referencing need to be considered as an
array rather than a range of values. For example, where each individual cell in
a range needs to be evaluated independently.
formulas other than that they offer an
element of protection to the formula without having to use worksheet
protection. The following examples illustrate the use of array formulas,
firstly showing functions which have to be entered as arrays and finally where
an array has to be used in order to obtain the correct result. Most array
functions tend to be specialised statistical calculations, the statistical
methods are not discussed.
Frequency Distribution.
A frequency
distribution calculates how often values occur within a range of values and
returns a vertical array of numbers. The calculation is done using the
FREQUENCY function:
For Further Course Details Visit Our Homepage
Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials
IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London
No comments:
Post a Comment