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

Excel Is Fun

Excel Magic Trick 1087

DESCRIPTION (08:00) Number Outside range with lower and upper hurdle. Numbers below the lower hurdle OR above the upper hurdle. (01:25) OR function. OR Criteria: only one TRUE is necessary for OR function to deliver [Read More >>>]

Excel Is Fun

Excel Magic Trick 1086

DESCRIPTION 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch & Merged Cell Trouble See how to:  (00:11 min) Create formula to lookup a value from a table with three criteria: INDEX and MATCH and [Read More >>>]

Excel Is Fun

Excel Magic Trick 1085

DESCRIPTION What if you are not allowed to have a helper columns to lookup Price and Region with VLOOKUP? And you need to calculate Total Revenue by Region? This video shows how to create a [Read More >>>]

Excel Is Fun

Excel Magic Trick 1084

DESCRIPTION See how to add every other column with the help of ISODD and the ISEVEN functions. Also SUMPRODUCT and COLUMN functions. Array Formula that does not require Ctrl + Shift + Enter because we [Read More >>>]

Excel Is Fun

Excel Magic Trick 1083

DESCRIPTION See how to Add Invoice Amounts Between Start and End Dates using the SUMIFS function, a start and end date in cells, the ampersand (join symbol) and comparative operators in double quotes. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1082

DESCRIPTION See how to add every other column using 1 or 4 formulas: (00:08 min) Manual method using SUM. See how to highlight non-contiguous columns using a comma or the Ctrl key. This formula will [Read More >>>]