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 | COUNTIF
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 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.
I recently received a request to use Conditional Formatting when performing two different comparisons on two data ranges. How I approached the task was WRONG! Read on to see how I finally got myself on the right track.
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.
Here is how you can take a vertical list of products and their ingredients and convert that into a table for easier viewing. In the process we will use the COLUMNS, COUNTIF, and VLOOKUP functions.