In this tutorial we are going to see how we can create a list of worksheets in our workbook, automatically create a hyperlink to each worksheet and make it dynamic so that when we add or delete any worksheet, the hyperlinked list will automatically update.
Tag Archives | ROW
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.
In this tutorial we’ll take a look at the ADDRESS function and how to use it to dynamically change the SUM range based on a selection from a Data Validation drop down list. We’ll also incorporate the INDIRECT, ROW, and MATCH functions.
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 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. […]