InLegacy Excel, you’ve got the option to use theOFFSET functionor theINDEX function.
All three approaches are explained below.
TAKE function
The TAKE function returns a subset of a givenarrayorrange.
In this configuration, OFFSET returns a 3-column range starting at cell F5 indatacontaining all 12 rows.
Note: theOFFSET functionis a volatile function and can cause performance problems in larger or more complicated worksheets.
If you run into this problem, see the INDEX solution below.
Together, the two INDEX functions return a reference to columns 4 through 6 in thedata(i.e.
F5:H16).
The number of rows and columns to return is provided by separaterowsandcolumnsarguments.
Rows and columns can be extracted from the start or end of the given array.
AVERAGE Function
The Excel AVERAGE function calculates the average (arithmetic mean) of supplied numbers.
OFFSET is handy in formulas that require a dynamic range.
COUNT Function
The Excel COUNT function returns a count of values that are numbers.
Numbers include negative numbers, percentages, dates, times, fractions, and formulas that return numbers.
you might use INDEX to retrieve individual values, or entire rows and columns.
