Excel Is Fun

Excel Magic Trick 1285

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1284

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 [Read More >>>]

Dueling Excel

Dueling Excel 121

DESCRIPTION MIN and MAX Between Two Dates For Each Region See Mr Excel and excelisfun use two methods to calculate MIN and MAX Between Two Dates For Each Region (Minimum value and maximum value with [Read More >>>]

Excel Is Fun

Excel Magic Trick 1217

D Functions: Text Criteria: “Starts With”, “Exact” and “Contains” DESCRIPTION For Text Criteria in D Functions (Like DSUM, DCOUNT, DMAX) learn about the difference between: “Starts With”, “Exact” and “Contains” Criteria. (00:10) Problem Setup (00:47) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1214

How To Enter Text Criteria Into Excel Database Functions DESCRIPTION See how to Enter Text Criteria Into Excel Database Functions using a Text Formula with the Comparative Operator Equal Sign. See these Examples: (00:09) Text [Read More >>>]