by Ilker | Feb 6, 2019 | Excel Tips & Tricks
Lookup functions are extremely useful when working with large data sets. Although they almost always work instantaneously with small data, larger data sets is when things can get rough in terms of performance, as large operations can require more computational...
by Ilker | Jul 13, 2018 | Excel Tips & Tricks
You can sum tables, columns, but what how do you add up every third row? In this article, we’re going to show you how to sum every n rows using the SUM and the OFFSET functions. The OFFSET function’s ability to return range is the key in this case. Syntax...
by Ilker | Jul 6, 2018 | Excel Tips & Tricks
Creating a dynamic Excel drop down list is very useful If you have a list that is updated frequently. This article shows you how to create a dynamic drop down list with the help of OFFSET and COUNTA functions. Syntax =OFFSET(title of list, 1, 0, COUNTA(column that...
by Ilker | Apr 25, 2018 | 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 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...