See an amazing formula from Bill Szysz at YouTube to create a Description Column for a transaction table. Thanks to Michale Diamond for the good question. See the formula elements: Shirking Range (Contracting Range), MATCH function, Wild cards to lookup text that has one or more characters, Question Mark Wild Card, Asterisk Wild Card, IFERROR function, ROWS function, VLOOKUP Function, IF Function. Also see Formula Evaluator to step through formulas to see the steps of evaluation.
Conditional Formatting VBA or OFFSET? DESCRIPTION See Mr Excel use VBA code for Conditional formatting and see excelisfun use the OFFSET, MOD and ROWS functions to do Conditional Formatting. WORKBOOKS
Lookup Two Criteria: SUMIFS, DGET, or Array Formula? DESCRIPTION See Mr Excel and excelisfun lookup a value given two criteria. You will see three formulas: SUMIFS formula, DGET formula, and an array formula that uses [Read More >>>]
DESCRIPTION See Mr Excel and excelisfun create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest. See the functions MAX, LARGE, SMALL, ROW, and ROWS functions. WORKBOOKS
EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.
Leave a Reply
You must be logged in to post a comment.