Media Summary: Download workbook: See how to: 1. Lookup First & Last Name From 2 See Excel 2003 formula that uses SMALL instead of AGGREGATE Related Video:

Excel Magic Trick 809 Diff - Detailed Analysis & Overview

Download workbook: See how to: 1. Lookup First & Last Name From 2 See Excel 2003 formula that uses SMALL instead of AGGREGATE Related Video:

Photo Gallery

Excel Magic Trick 809: Diff Workbook: Advanced Filter Extract  Unique Records & Adding W Criteria
Excel Magic Trick 824: Two Way Lookup With More Than One Lookup Table Same or Different Sheets
Excel Magic Trick 989: Conditional Formatting For Values above 90% Percentile Mark
Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable
Extract Data From Excel Cell. 4 Different Methods! Excel Magic Trick 1664
Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2
Excel Magic Trick 1120: Is Item in All Three Lists?
Excel Magic Trick 915: What Exactly Does VLOOKUP Do? What Is Purpose Of VLOOKUP? 9 Examples
Excel Magic Trick #176 Get Last Item in Column on Diff Sheet
Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together
Excel Magic Trick 909: Paste Special Values
Excel Magic Trick 901: Lookup First & Last Name From 2 Different Cells & Return Then To 1 Cell
Sponsored
Sponsored
View Detailed Profile
Excel Magic Trick 809: Diff Workbook: Advanced Filter Extract  Unique Records & Adding W Criteria

Excel Magic Trick 809: Diff Workbook: Advanced Filter Extract Unique Records & Adding W Criteria

Download

Excel Magic Trick 824: Two Way Lookup With More Than One Lookup Table Same or Different Sheets

Excel Magic Trick 824: Two Way Lookup With More Than One Lookup Table Same or Different Sheets

Download

Sponsored
Excel Magic Trick 989: Conditional Formatting For Values above 90% Percentile Mark

Excel Magic Trick 989: Conditional Formatting For Values above 90% Percentile Mark

Download

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

Extract Data From Excel Cell. 4 Different Methods! Excel Magic Trick 1664

Extract Data From Excel Cell. 4 Different Methods! Excel Magic Trick 1664

Download

Sponsored
Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2

Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2

Download

Excel Magic Trick 1120: Is Item in All Three Lists?

Excel Magic Trick 1120: Is Item in All Three Lists?

Download

Excel Magic Trick 915: What Exactly Does VLOOKUP Do? What Is Purpose Of VLOOKUP? 9 Examples

Excel Magic Trick 915: What Exactly Does VLOOKUP Do? What Is Purpose Of VLOOKUP? 9 Examples

Download

Excel Magic Trick #176 Get Last Item in Column on Diff Sheet

Excel Magic Trick #176 Get Last Item in Column on Diff Sheet

Download

Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together

Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together

Download

Excel Magic Trick 909: Paste Special Values

Excel Magic Trick 909: Paste Special Values

Download

Excel Magic Trick 901: Lookup First & Last Name From 2 Different Cells & Return Then To 1 Cell

Excel Magic Trick 901: Lookup First & Last Name From 2 Different Cells & Return Then To 1 Cell

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to: 1. Lookup First & Last Name From 2

Excel Magic Trick 1234: VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Range

Excel Magic Trick 1234: VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Range

Download

Excel Magic Trick 1156: Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods)

Excel Magic Trick 1156: Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods)

Download

Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables

Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables

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 994: Min Digit From A Cell: MIN or AGGREGATE Array Formula?

Excel Magic Trick 994: Min Digit From A Cell: MIN or AGGREGATE Array Formula?

Download

Excel Magic Trick 1184: Formula to Create Alpha Numeric Series X20, X25, X39…

Excel Magic Trick 1184: Formula to Create Alpha Numeric Series X20, X25, X39…

Download

Related Video Content

Office 365 login information

Collaborate for free with online versions of Microsoft Word, PowerPoint, Excel, and OneNote. Save documents,...

Microsoft Excel - Download information

Feb 16, 2026 · Microsoft Excel is built for organizing data, running calculations, and turning tables into decisions....

Microsoft Excel: Spreadsheets - Apps on Google Play information

Spreadsheets & Calculations • Create charts, budgets, project plans, accounting & financial analysis with Excel's...

Microsoft Excel - App Store information

Download Microsoft Excel by Microsoft Corporation on the App Store. See screenshots, ratings and reviews, user tips,...

Download Microsoft Excel for Windows, macOS, Android, APK ... - Gizmodo information

1 day ago · Microsoft Excel is a spreadsheet program from Microsoft and one of the core applications in the Microsoft...