In this tutorial we’ll see how we can use Conditional Formatting, using the ISBLANK, COUNTIF, and INDIRECT functions, to verify the accuracy of selections from a Data Validation drop down list in Excel.
Tag Archives | INDIRECT
I’ve done three posts in the past on how to select photos using a drop down list. This series has turned out to be my most popular of all my posts. With all the questions and comments I get, there are two issues that are the most common errors that folks commit when setting up […]
In this tutorial we are going to explore a variation of the traditional INDEX/MATCH combination to extract and sum only a portion of a row or column within an array.
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. […]
In this video we’ll look at the traditional data range lookup using the INDEX and MATCH functions, but add a twist to look up the values in a table, plus a bonus twist using the INDIRECT function.
In this video we’ll create a single formula that can be copied down through thousands of rows that will determine if each student completed a varying number of components of a project. In the process we will use the AND, COUNTIF, IF, INDIRECT, MATCH, and VLOOKUP functions.