In this tutorial we will use Data Validation with lists, formulas and add a Form Control spinner button to limit the entry of numbers into a cell.
Tag Archives | AND
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 learn how to incorporate multiple criteria into the same cells to prohibit invalid entries when using Data Validation. We’ll also learn about the Ignore Blank option and incorporate the AND and MOD functions.
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 use Advanced Filter for AND or OR scenarios in Excel…..