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.
DESCRIPTION See how to use the MEDIAN function is unusual ways that allow you to shorten the formula (for last two examples): (00:09) Deliver an OR Criteria Logical Value. (02:15) Payroll Tax calculation where there [Read More >>>]
DESCRIPTION In this video learn how to take Invoice Shipping and Discount Amounts from an Invoice Level (Header) Transaction or Fact Table and allocate those amounts to the Invoice Line Item Level Fact Table so [Read More >>>]
DESCRIPTION See how to: (00:10) Introduction (00:52) XNPV, OFFSET and VLOOKUP formula to calculate the Net Present Value for each Project (10:45) XIRR, OFFSET and VLOOKUP formula to calculate the Net Present Value for each [Read More >>>]
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.