View Detailed Profile
Excel Magic Trick 581: Unique List With Criteria Using Advanced Filter

Excel Magic Trick 581: Unique List With Criteria Using Advanced Filter

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT579-

Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally

Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally

Download

Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates

Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates

Download

Excel Magic Trick 167p1 IF function formula: 12 Examples!

Excel Magic Trick 167p1 IF function formula: 12 Examples!

Excel If statement

Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take

Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take

Download

Excel Magic Trick 1481: Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too

Excel Magic Trick 1481: Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too

Download Files: Start

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 1313: Array Formula to Create Sorted Unique List in Cell. HUGE Formula. TEXTJOIN.

Excel Magic Trick 1313: Array Formula to Create Sorted Unique List in Cell. HUGE Formula. TEXTJOIN.

Download

Excel Magic Trick 1485: SUMIFS & MAXIFS Functions: Lookup Correct Price Based on Effective Date

Excel Magic Trick 1485: SUMIFS & MAXIFS Functions: Lookup Correct Price Based on Effective Date

Related Videos:

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 899: Lookup Column of Data, Match Criterion, Display Items Vertically

Excel Magic Trick 899: Lookup Column of Data, Match Criterion, Display Items Vertically

See Excel 2003 formula that uses SMALL instead of AGGREGATE Related Video:

Excel Magic Trick 1018: CEILING Function To Round Up To The Nearest $1000 Increment

Excel Magic Trick 1018: CEILING Function To Round Up To The Nearest $1000 Increment

Download

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?

Related Video: