Excel Is Fun

Excel Magic Trick 1097

DESCRIPTION See how to: (00:11) AND and OR Criteria. (01:14) Counting Formula with SUMPRODUCT and COUNTIFS and a function argument array operation (03:16) Adding Formula with SUMPRODUCT and SUMIFS and a function argument array operation [Read More >>>]

Excel Is Fun

Excel Magic Trick 1096

DESCRIPTION See how to extract date from middle of text string with a formula that uses SUBSTITUTE, SEARCH and MID functions. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1095

DESCRIPTION See how to count Doubles, triples, quadruples, etc. using FREQUENCY function rather than COUNTIF. FREQUENCY is much faster calculating. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1094

DESCRIPTION See how to lookup all A8 cell references from across many sheets using a wildcards, incomplete sheet names and the INDIRECT function. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1093

DESCRIPTION Extract Date from Middle of Description: Text To Columns or Formula: 1. Text To Columns 2. Formula that uses the functions SUBSTITUTE, REPLACE, SEARCH and LEFT WORKBOOKS

Excel Is Fun

Excel Magic Trick 1092

DESCRIPTION See how to build an array formula that uses the COUNTIF & SUMPRODUCT functions as well as a function argument array operation, a comparative array operation and a math array operation in a single [Read More >>>]

Excel Is Fun

Excel Magic Trick 1091

DESCRIPTION See how to count the number of items entered into the row that corresponds to the first occurrence of each Group Number using: 1) INDEX, MATCH and COUNTA functions to “lookup a row” for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1090

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 >>>]

Excel Is Fun

Excel Magic Trick 1089

DESCRIPTION Mr Excel did Month, Year To Date and Variances from data set with GETPIVOTDATA function. See excelisfun do it with Formulas Advanced Filter/Unique List. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1088

DESCRIPTION Show All B7 values From Across Sheets that are Named 01, 02, 03, …10, 11… using the functions: INDIRECT, TEXT and ROWS WORKBOOKS