Dueling Excel

Dueling Excel 037

Evaluate Text Math VBA, Excel 4 Macro Function, MoreFunc add-in? DESCRIPTION See Mr Excel and excelisfun take math formulas stored as text and evaluate then using three methods: VBA, Excel 4 Macro Function or the [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 >>>]

Dueling Excel

Dueling Excel 036

VLOOKUP w Approximate Match & Unsorted Table DESCRIPTION See Mr Excel and excelisfun do a VLOOKUP for an approximate match when the table is not sorted. See Mr Excel create the exact match for his [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 >>>]

Dueling Excel

Dueling Excel 035

3 Way Lookup INDEX or OFFSET function? DESCRIPTION See Mr Excel and excelisfun do a three way lookup. Compare a method that uses INDEX, MATCH and OFFSET function to a second method that uses INDEX [Read More >>>]