Select Page

## UNIQUE Function

The Excel UNIQUE function is a lookup and reference formula that returns a list of unique values from a list or range. This formula is one of the newest Dynamic Array functions to be released with Excel 2019. In this guide, we’re going to show you how to use the Excel...

## How to delete blank rows and columns at the end of worksheets using VBA

Excel doesn't always update the range of cells you've used in worksheets when you modify them. This can result in a larger file size and have performance impacts, even after you clear cell contents. The easiest way to fix this is by deleting the blank rows and columns...

## Function: MATCH

Excel MATCH function is a lookup/reference formula that returns the relative position of a lookup value from a specified range. The position can be used as the index value in other lookup functions. In this guide, we’re going to show you how to use the Excel MATCH...

## Function: INDEX

The Excel INDEX function returns a value or the reference of a value at a given position in a range or array. The INDEX function has two different forms to return a value or a reference. Using an array form returns a value, while a reference form returns a reference....

## How to speed up lookup formulas

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

## Function: IFS

The IFS function evaluates multiple conditions until finding first TRUE condition. It is intended to replace nested IF statements containing multiple IF functions. In this guide, we’re going to show you how to use the IFS function and also go over some tips and error...

## Function: SWITCH

The SWITCH function evaluates the value in its first argument against the value-result pairs defined with them, and returns the matched pair if there is a match, and the default value if there isn’t. The SWITCH function is a good alternative to the IF function...

## How to use IFS and SWITCH formulas instead of nested IF statements

Nested IF statements are useful for creating more complicated scenarios in Excel. However, IFS and SWITCH formulas can work more efficiently when dealing with more than one condition. These formulas work a bit differently than the legacy IF function. Let’s start...

## Function: MIRR

The MIRR Excel function is a finance function that calculates the modified internal rate of return (MIRR) for a series of periodic cash flows. This function works by using both the cost of the investment and the interest received by reinvesting the cash. In this...