DESCRIPTION See how to: (00:15) Introduction to Contains Criteria (Partial Text Criteria) in an OR Logical Test, when search for records with Multiple Contains Criteria. (02:00) #1 Filter & Helper Column with Formula that uses [Read More >>>]
Dynamic Chart to Plot Daily Changes in Meter Readings DESCRIPTION Learn how to create a dynamic chart that updates when daily meter readings are entered into a table (00:10) Problem Setup (00:50) IF function and [Read More >>>]
DESCRIPTION See how to Compare Two Lists and Extract Records: 1. ISNA and MATCH function with Filter to extract items in list 2 that are NOT in List 1. 2. ISNUMBER and MATCH function with [Read More >>>]
Be the first to comment
EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.