# Tag Archives | COUNTIF

## How To Use Conditional Formatting To Verify Selections Of A Drop Down List In Excel

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.

## How To Create An Error Message When Using Dynamic Data Validation 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.

## How To Do A Lookup In Excel Of Unique Values In A Table That Has Several Of The Same Items

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.

## You Need To Change How You Think When Using Formulas In Conditional Formatting!

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.

## How To Create A Single Formula to Determine If All Parts Of A Project Are Complete In Excel

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.

## How To Convert A Vertical List Into A Table In Excel

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.