Excel Is Fun

Excel Magic Trick 1122

April 22, 2015 0

DESCRIPTION 1. Excel 2010 or later formula when day is indicated with the number 1 2. Formula Excel 2010 or later formula when day is indicated with the number 1 or an “x” 3. Excel […]

Excel Is Fun

Excel Magic Trick 1121

April 21, 2015 0

DESCRIPTION See how to: Calculate Compounding Rate/Geometric Mean with the new RRI function in Excel 2013 WORKBOOKS

Excel Is Fun

Excel Magic Trick 1120

April 20, 2015 0

DESCRIPTION See how to create a Logical Formula that will check whether an item in in all three lists using 2 MATCH functions and the ISNUMBER function. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1119

April 19, 2015 0

DESCRIPTION See how to: 1. Create formula for Conditionally Formatting a Date when 44 days have passed 2. Create formula to Conditionally Formatting the whole row when 44 days have elapsed after a given date. […]

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