In this tutorial we will use the AND function along with SUM and MOD in Data Validation to control the distribution of inventory to various locations.
Tag Archives | Data Validation
In this tutorial we are going to look at a typical INDEX / MATCH combination formula but with a twist that concatenates both the lookup values and the arrays that are being looked into, making it an array formula.
In this tutorial we’ll take a look at the ADDRESS function and how to use it to dynamically change the SUM range based on a selection from a Data Validation drop down list. We’ll also incorporate the INDIRECT, ROW, and MATCH functions.
In this video we’ll take a look at how to modify previous videos I’ve done on pulling in photos tied to a drop down list by adding an option so that if nothing is selected, a blank cell will appear.
In this tutorial we’re going to go through all the various options that Excel offers with the Go To Special command. This is one of my favorite options in Excel and I use it practically every day. So take a few minutes and you too will see all the benefits of Go To Special in […]
In this tutorial we are going to use a named range that incorporates the OFFSET and COUNTA functions to create a dynamic range for our Data Validation drop down list in Excel.