Excel Is Fun

Excel Magic Trick 1118

April 18, 2015 0

DESCRIPTION See how to Extract Word That Occurs Most Frequently: (00:07) MODE calculation for text. (00:57) COUNTIFS function for basic mode calculation (01:38) INDEX, MODE and MATCH function (with function argument array operation) to extract […]

Excel Is Fun

Excel Magic Trick 1117

April 17, 2015 0

DESCRIPTION See how to calculate an average for 12 different samples when numbers are in a single column: (00:25) PivotTable (average in one condition/criteria) (02:22) AVERAGEIFS Function (average in one condition/criteria) (05:37) AVERAGE, ROWS and […]

Excel Is Fun

Excel Magic Trick 1116

April 16, 2015 0

DESCRIPTION (00:37) INDEX and MATCH when we have a two fields (columns): Sample Number and Number To Be Averaged. Use MATCH to lookup first occurrence of each sample number with Exact Match, which only finds […]

Excel Is Fun

Excel Magic Trick 1115

March 15, 2015 0

DESCRIPTION PivotTable to Count How Many of Each Item There Are In a Column WORKBOOKS

Excel Is Fun

Excel Magic Trick 1114

March 14, 2015 0

DESCRIPTION See how to create formula for Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 1, 18443 2, 18444 2, 18445 2, 18446 3…. See formula that uses the functions ROWS, INT and the […]

Excel Is Fun

Excel Magic Trick 1113

March 11, 2015 0

DESCRIPTION 1. Text To Columns using Fixed Width, One Time Event 2. Formula that will update when data changes. Formula uses MID and COLUMNS functions and Mixed Cell References. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1112

March 10, 2015 0

DESCRIPTION (01:06) Group By Date In PivotTable Error (Cannot group that selection error) (01:42) Text To Columns To Convert Text Dates To Dates (02:53) Text To Columns Fatal Error (Microsoft Excel has stopped working error) […]

Excel Is Fun

Excel Magic Trick 1111

March 9, 2015 0

DESCRIPTION See how to extract items in List 2 that are also in List 1 using a great array formula from Exceli Adam at YouTube that uses the functions IF, INDEX, MATCH and AGGREGATE. MATCH […]

Excel Is Fun

Excel Magic Trick 1110

March 8, 2015 0

DESCRIPTION See how to compare two lists and extract records with an array formula that uses these functions: MATCH, ISNA, ISNUMBER, IF, ROWS, ROW, INDEX, AGGREGATE and a number of array operations. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1109

March 7, 2015 0

DESCRIPTION See how to Compare Two Lists and Extract Records with Excel Advanced Filter: 1. Extract items in list 2 that are NOT in List 1 using Advanced Filter and Logical Formula in Criteria Area […]