### Excel Magic Trick 1311

August 7, 2017

DESCRIPTION See an Array Formula that can extract (from a proper data set) multiple invoice items for one lookup value & show total. See the functions: COUNTIFS, ROW, AGGREGATE, ROWS, INDEX, IF and SUMIFS. See […]

### Dueling Excel 134

March 22, 2017

DESCRIPTION Merge Product and Sub-Product Text; VBA or Wild INDEX Formula See Mr Excel and excelisfun use two methods to take a table of product names, each with 6 sub-products, and unwind the table to […]

### Worksheet Basics

March 2, 2017

INTRODUCTION There are two types of worksheets. The standard worksheets that contains cells. Chart sheets which contain only graphs. ROWS AND COLUMNS Every standard worksheet layout consists of Rows and Columns. Rows numbered from 1 […]

### Highline Excel 2013 Class Video 24

February 24, 2017

Getting Top 5 Values With LARGE And Bottom 5 With SMALL DESCRIPTION Topics in this video: 1. Getting Top five values with LARGE and ROWS 2. Getting Bottom five values with SMALL and ROWS WORKBOOKS

### Excel Magic Trick 1226

September 1, 2016

DESCRIPTION Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) Learn how to Compare 2 Lists, Extract Items In List 2 That are NOT in List 1: (00:12) […]

### Dueling Excel 98

August 31, 2016

Extract & Lookup Number When Table Of Numbers Is In A Single Cell DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Check whether Numbers In Cell C2 Also In F2? 2. Mr […]

### Dueling Excel 81

June 8, 2016

Extract Multiple Records Based on Two Criteria VBA or Formula DESCRIPTION See Mr Excel and excelisfun Extract Multiple Records Based on Two Criteria using VBA and formula. See the functions AND, SUM, VLOOKUP, ROWS, COLUMNS […]

### Excel Magic Trick 1190

February 1, 2016

Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for […]

### Excel Magic Trick 1187

January 11, 2016

Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functions DESCRIPTION See how to create a formula to Lookup Every 5th Item In a Column using INDEX and ROWS functions.

### Excel Magic Trick 1184

December 21, 2015

Formula to Create Alpha Numeric Series X20, X25, X39… DESCRIPTION See how to create formula to create Alpha Numeric Series X20, X25, X39… using ROWS function. See the ROWS function and an expandable range to […]