In this tutorial we are going to use a simple but creative way to determine the number of unique items in a list in Excel. We’ll use the SUM and COUNTIF functions in an array formula to accomplish this. We’ll also do it manually using Remove Duplicates as a comparison.
Tag Archives | COUNTIF
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.
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.