In this tutorial we are going to see how we can use an array formula using IFERROR, INDEX, SMALL, IF and ROW functions to create a dynamic, filtered list without using any built-in Excel functions like Filter to accomplish this.
Tag Archives | SMALL
In this tutorial we’ll take a look at how to use an array formula utilizing INDEX, IF, SMALL and ROW functions to extract unique values from a large list into a table based on a specific criteria.
In this tutorial we are going to do a lookup from one table that has multiple quantities for the same items, and ensure that we only pull each unique quantity once into another table sorted in a different order.
In this tutorial we are going to look at two ways that you can calculate the average sales of accounts, but eliminating the top 5 and bottom 5 accounts which may distort the overall average.
Let’s take a look at how we can retrieve multiple results from a table based on a single selection using an array formula. In the process we will utilize Array formulas and the functions IF, IFERROR, INDEX, LOOKUP, ROW and SMALL.