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.
Tag Archives | IF
In this tutorial we’ll look at how to randomly pair two teams from a list of 10, five from each of two countries, but with the condition that we can’t pair two teams from the same country. We’ll use IF, RANDBETWEEN, and CHOOSE functions to accomplish this. Here we go!
In this tutorial we are going to use the IF and SUMPRODUCT functions to determine if a series of courses or requirements have been completed for a student or employee. We will also use Conditional Formatting to make the results more visual.
In this tutorial we are going to look at two methods of labeling or numbering accounts, locations, inventory, etc. using IF statements and Custom Formatting to count the frequency in a list or label the items in a sequence.
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 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.