Excel Is Fun

Excel Magic Trick 1099

February 6, 2015 0

DESCRIPTION See how to compare two e-mail lists where one list has extra semi-colons and we want a dynamic formula that can handle periodic data dumps. (00:08) Setup of problem (00:46) Excel Table Feature to […]

Excel Is Fun

Excel Magic Trick 1098

February 5, 2015 0

DESCRIPTION See how to compare two e-mail lists where one list has extra semi-colons: (00:28) Find and Replace feature to remove semi-colons (Ctrl + H). (01:32) Is in List: MATCH and ISNUMBER functions. (03:20) Is […]

Excel Is Fun

Excel Magic Trick 1097

February 4, 2015 0

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

Excel Is Fun

Excel Magic Trick 1096

February 3, 2015 0

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

February 2, 2015 0

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

February 1, 2015 0

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

January 22, 2015 0

Extract Date from Middle of Description: Text To Columns or Formula? DESCRIPTION Extract Date from Middle of Description: Text To Columns or Formula: 1. Text To Columns 2. Formula that uses the functions SUBSTITUTE, REPLACE, […]

Excel Is Fun

Excel Magic Trick 1092

January 21, 2015 0

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

Excel Is Fun

Excel Magic Trick 1091

January 16, 2015 0

Count Number of Items In Row For First Occurrence of Each Group DESCRIPTION See how to count the number of items entered into the row that corresponds to the first occurrence of each Group Number […]

Excel Is Fun

Excel Magic Trick 1090

January 14, 2015 0

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