OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) DESCRIPTION Learn how to calculate the MIN and MAX values when there is complex criteria that mixes OR Logical Tests and AND Logical […]
DESCRIPTION Variable Rent Calculation Based On Days: VBA, IF or VLOOKUP? See Mr Excel and excelisfun use two methods to calculate the total rent for a container based on a sliding scale: 1. VBA with […]
History of Excel Max or Min with Conditions / Criteria (5 Examples) DESCRIPTION Learn about 5 methods to make a Max or Min AND Criteria (AND Logical Test) Calculation with multiple Conditions / Criteria that […]
DESCRIPTION Discover how to apply mixed absolute cell references to quickly complete a table of calculations in Microsoft Excel (applicable to all versions of Excel).
Flash Fill: Extract, Combine, Insert, Reverse Data (25 Example) DESCRIPTION Topics in this video: 1. Extract First Name. 2. Extract Last Name. 3. Formulas or Flash Fill?. 4. Extract First and Last Initial. 5. Flash […]
DESCRIPTION From Text to Math: VBA or Excel 4 Macro Function: EVALUATION See Mr Excel and excelisfun use two methods to convert a text string to a match expression that can calculate the correct answer: […]
Lookup And Return Multiple Items to a Single Cell: TEXTJOIN Function DESCRIPTION See how to use the amazing new Excel 2016 function TEXTJOIN to Find Multiple Lookup Values In First Colum AND return Multiple Items […]
Excel Data Validation: List, Date, Time, Custom (22 Examples) DESCRIPTION Topics in this video: 1. Data Validation to allow only whole numbers between an upper and lower limit. 2. Create an Input Message for your […]