by Ilker | Apr 25, 2018 | Excel Formulas, Excel Tips & Tricks
To return an entire row you need to use array returning functions like INDEX or OFFSET. Both of these functions can return arrays, as well as single values, which can be used in other functions like SUM, AVERAGE or even another INDEX or OFFSET. How to return an entire...
by Ilker | Apr 25, 2018 | Excel Formulas, Excel Tips & Tricks
To return an entire column you need array returning functions like INDEX or OFFSET. Both of these functions can return arrays, as well as single values, which can be used in other functions like SUM, AVERAGE or even another INDEX or OFFSET. How to return an entire...
by Ilker | Apr 2, 2018 | Excel Tips & Tricks
A final exam is worth more in terms of graduation score and the term weighed average becomes relevant. In such cases, SUMPRODUCT formula can help calculate the weighed totals of a data set. In our example, test scores of 3 candidates are being compared. Although...
