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 | Data Validation
In this tutorial we will discuss how to dynamically and automatically change the markers in a chart to highlight the values based on the series selected in a Data Validation drop down list.
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.
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’ll look at how to dynamically pull the salaries of all employees from a list, for the period of the date selected.
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.