Excel Magic Trick 1383

Conditional Format Row w OR Logical Test with Multiple Partial Text Criteria

DESCRIPTION

See how to Conditionally Format each row in a Data Set that has a Job Title that contains any text item from within a list. Learn about “Contains Criteria” in an OR Logical Test:
(00:11) Introduction
(02:53) OR, ISNUMBER and SEARCH functions in an Logical Array Formula that requires Ctrl + Shift + Enter (in the cells). Learn how Array Formulas that require Ctrl + Shift + Enter will work in the Conditional Formatting Dialog Box.
(08:45) Convert Contains Criteria list to an Excel Table to allow the list of criteria to expand or contract.
(10:13) LOOKUP and SEARCH functions in an Logical Array Formula that does NOT requires Ctrl + Shift + Enter (in the cells). Learn how the Big Number 2^15 can be used in an Approximate Match Lookup Formula when searching for text in a cell.
(13:35) Summary
Not in video, but in the downloadable Workbook compare and time the LOOKUP Formula using either SEARCH or MATCH functions.

WORKBOOKS

Download “Excel Magic Trick 1381-1385” Excel-Magic-Trick-1381-1385.zip – Downloaded 80 times – 81 MB







Be the first to comment

Leave a Reply