Array Formulas in Excel: All You Need to Know

Array Formulas in Excel

Array formulas are an advanced topic in Excel. Usually Excel users discover them when reaching the limits of – let’s call them – normal formulas, e.g. SUM, VLOOKUP, COUNT and so on. This article provides an introduction of array formulas in Excel.

Count Number of Unique Records in Excel: 5 Methods (+Download)

Count Number of Unique Records in Excel

A common task in Excel is to find out the number of different entries in a list. For example, you have a list of names and want to know, how many different people are listed as some people might be multiple times on the list. This article introduces 5 different methods of counting the number… Continue reading Count Number of Unique Records in Excel: 5 Methods (+Download)

MINIF & MAXIF: 5 Ways to Insert a Conditional Minimum/Maximum Value

Until Excel 2016, there is no built-in MINIF-Formula in Excel. There are COUNTIF, SUMIF, AVERAGEIF but no MINIF nor MAXIF before the latest version. However, there are situations in which you need to get the minimum under a condition. In the following post, we are going to illustrate how to returnthe minimum using a simple example.… Continue reading MINIF & MAXIF: 5 Ways to Insert a Conditional Minimum/Maximum Value