In this tutorial we are going to use the MAX and IF functions in an array formula, along with INDEX and MATCH to extract the last date in a list of events that is less than a control date and the event related to that date.
Tag Archives | IF
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.
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 IF, SUMPRODUCT, and ISNUMBER to figure out the difference between summing values that add up to zero vs. summing blank cells in Excel.
When using dynamic Data Validation, there are points when the item shown does not match the category listed> In this tutorial, I’ll show you how to write a formula to advise the user that another item needs to be chosen. We’ll use four functions to accomplish this: IF, OFFSET, MATCH and COUNTIF.
In this tutorial we’ll look at how to randomly pair two teams from a list of 10, five from each of two countries, but with the condition that we can’t pair two teams from the same country. We’ll use IF, RANDBETWEEN, and CHOOSE functions to accomplish this. Here we go!