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.
Tag Archives | SMALL
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.