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 | IFERROR
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 are going to use the LOOKUP function to find the last match in an array and return the corresponding value from another column from that row.
In this tutorial we’ll take a look at how to add a column with a formula outside of our PivotTable for project analysis that pulls results from a Table, then use Conditional Formatting to dress it up.
Here is how you can take a list and create a formula to repeat the items in that list the given number of times you specify. We will use the IFERROR, ROUNDUP, INDEX and ROWS functions in the process.
Here is how to calculate the number of days between multiple events over a specified time period. In this process we will use the IF, IFERROR and LARGE functions and utilize Array formulas.