Excel Is Fun

Excel Magic Trick 1154

Unique Count:Name & Date & Criteria From 3rd Column (3 Methods) DESCRIPTION See how to Unique Count For Name & Date & Criteria From 3rd Column: (00:08) Problem Setup (00:50) Array Formula. Learn about IF [Read More >>>]

Excel Is Fun

Excel Magic Trick 1153

Unique Count For Name & Date: Array Formula, 2013 PivotTable, More… DESCRIPTION See how to: (00:08) Problem Set Up (00:55) Excel 2013 PivotTable and “Add to Data Model” to get Distinct Count Formula (02:38) Remove [Read More >>>]

Excel Is Fun

Excel Magic Trick 1152

Formula or Power Query: Cost Report When Product IDs Don’t Match DESCRIPTION See how to create Total Cost Report when Product IDs in transaction table do NOT match Product IDs in Lookup Table: (00:08) Set [Read More >>>]

Excel Is Fun

Excel Magic Trick 1151

Get Two Tables Into Pivot Table Field List using Excel 2013 DESCRIPTION See how to Get Two Tables Into Pivot Table Field List using Excel 2013 to create a Report based on Revenue from one [Read More >>>]

Excel Is Fun

Excel Magic Trick 1150

Power Query: Dynamically Sum by Category without VLOOKUP Helper Column DESCRIPTION See how to: Power Query: Dynamically Sum by Category without VLOOKUP Helper Column: 1) From Table 2) Close and Load. Close and Load to… [Read More >>>]

Excel Is Fun

Excel Magic Trick 1149

Dynamically Sum by Category without VLOOKUP Helper Column (2 methods) DESCRIPTION See how to: Dynamically Sum Costs by Category without VLOOKUP Helper Column: (00:47) VLOOKUP helper Column and SUMIFS function (03:10) Array Formula using SUMPRODUCT [Read More >>>]

Excel Is Fun

Excel Magic Trick 1148

Calculate Retirement Year Based On 80 Rule DESCRIPTION See how to: Formula To Calculate Retirement Year Based On 80 Rule: (00:55) DATEDIF function (02:44) Goal Seek (04:19) Destiny Williams Formula WORKBOOKS

Excel Is Fun

Excel Magic Trick 1147

Incorrect Formula To Calculate Retirement Year DESCRIPTION See how to: (00:07) 80 Rule For Retirement Age (00:48) Formula for Year of Retirement using YEAR function. (01:09) Wipe away Date Number Format by applying the General [Read More >>>]

Excel Is Fun

Excel Magic Trick 1146

Create ISO Dates using TEXT function and Custom Number Format DESCRIPTION See how to: 1. Create ISO Dates using TEXT function and Custom Number Format. Like; =TEXT(A5,”yyyymmdd”) 2. Compare two columns of formulas to check [Read More >>>]

Excel Is Fun

Excel Magic Trick 1145

Create Random Data Set with Formulas: 4 Unusual Formulas DESCRIPTION See how to: (00:08) Overview of Different data Types (01:02) FORMULA 1: Create Random Serial Number Dates with RANDBETWEEN and actual Serial Numbers (02:10) Keyboards [Read More >>>]