Resources

How to create dependent dropdowns

Dropdown type of inputs are very common in Excel models, but dependent dropdowns take it to the next level, and are dynamic. This means that available options of the dropdown menu will change based on other selections. This article will show you how to...

How to remove blanks from a list

We often find data in a raw, unorganized form that contain empty cells. In this article we're going to show you how to remove blanks from a list and create a new table using only formulas. Syntax =IFERROR(INDEX(list range,SMALL(IF(ISTEXT(list...

How to convert a number to time units

If you want to convert a number to time values, you need some additional operations, multiplying and dividing between days, hours, minutes, and seconds. Here, we're going to take a look at a simpler approach by using Excel's TEXT function.   Syntax...

How to highlight a column

To highlight a column may be tricky because there is no built-in option in Excel's Conditional Formatting feature. Here, you can find out how you can do this dynamically using Excel formulas. Steps Begin by selecting rows by clicking on column letters Open...

How to highlight a row

To highlight a row may be tricky because there is no built-in option to in Excel's Conditional Formatting feature. Here, you can find out how you can do this dynamically using Excel formulas. Steps Begin by selecting rows by clicking on row numbers Open...

How to return an entire row

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...

How to return an entire column

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...