View Detailed Profile
Excel Magic Trick 1166: Count Dates From Date-Time Values: COUNTIFS or PivotTable?

Excel Magic Trick 1166: Count Dates From Date-Time Values: COUNTIFS or PivotTable?

Download

Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula

Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula

Related Videos: Excel

Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT

Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT

Download

Excel Magic Trick 1146: Create ISO Dates using TEXT function and Custom Number Format

Excel Magic Trick 1146: Create ISO Dates using TEXT function and Custom Number Format

Download

Excel Magic Trick 1168: Get Time Value From Date Time Value (2 Formula Examples)

Excel Magic Trick 1168: Get Time Value From Date Time Value (2 Formula Examples)

Download

Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods

Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods

Download

Excel Magic Trick 1197: OR Criteria: Don’t Double Count: DCOUNTA, COUNTIFS, or SUMPRODUCT?

Excel Magic Trick 1197: OR Criteria: Don’t Double Count: DCOUNTA, COUNTIFS, or SUMPRODUCT?

Download

Excel Magic Trick 1164: Average Score After Subtracting Two Lowest: SMALL & Array or AVEAGEIF?

Excel Magic Trick 1164: Average Score After Subtracting Two Lowest: SMALL & Array or AVEAGEIF?

Download

Excel Formula for Lookup Counting with COUNTIFS & SUM- Excel Magic Trick 1603

Excel Formula for Lookup Counting with COUNTIFS & SUM- Excel Magic Trick 1603

Download

Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?

Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?

Download Excel Start File: https://excelisfun.net/files/EMT1178.xlsx

Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable

Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable

Download

Excel Magic Trick 1191: VLOOKUP: Lookup Temperature and Return to Bat Observation Table

Excel Magic Trick 1191: VLOOKUP: Lookup Temperature and Return to Bat Observation Table

Download

Excel Magic Trick 1376: Complex VLOOKUP Formula To Create Transaction Description

Excel Magic Trick 1376: Complex VLOOKUP Formula To Create Transaction Description

Start File and Finished File: https://excelisfun.net/files/EMT1376.xlsx See an amazing formula from Bill Szysz at YouTube to create ...