DESCRIPTION See how to create a formula to list incomplete / missing student assignments: (00:11) Introduction (01:14) Formula to count missing assignments for a particular student using: 1) INDEX & MATCH functions to lookup a [Read More >>>]
DESCRIPTION Learn how to avoid long formula with multiple IF Functions by using the lookup functions: VLOOKUP or LOOKUP. Also see a “Partial Text Lookup” Situation where we have to lookup just part of a [Read More >>>]
Conditional Format Grades To Assign Icons To 1 of 3 Groups (3 Methods) DESCRIPTION See how to use Conditional Format Grades to assign Stop Light Icons to one of three groups: Green Icons, Yellow Icons [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.