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 | ROW
In this tutorial I’ve created a formula that can retrieve a list of items, repeat that list, and automatically adjust if items are added to or deleted from that list. You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner. […]
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.
Here are two ways that you can band the rows of your data range to make it easier to read the data across your table. We will utilize the MOD and ROW functions in the process.
Here is how to use the ADDRESS function along with ROW, COLUMN, INDIRECT and Data Validation In Excel…..
Here is how I used OFFSET and 5 other functions to convert a data range into a single column in Excel…..