### Excel Magic Trick 1220

August 11, 2016

How To Put Double Quotes In Text Formula: Extra Double Quotes Or VLOOKUP DESCRIPTION Learn how to either use IF function and Extra Double Quotes or VLOOKUP to put the text 5’6” or 6’ into […]

### Highline Excel 2016 Class 02

July 24, 2016

Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excel’s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text […]

### Dueling Excel 86

July 13, 2016

MODE or MEDIAN From Frequency Table Formula or VBA? DESCRIPTION See Mr Excel and excelisfun use two methods calculate MODE or MEDIAN From Frequency Table – Formula or VBA. See the functions, AND, COUNTIF, MAX, […]

### 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 […]

### Dueling Excel 75

April 27, 2016

Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX? DESCRIPTION See Mr Excel and excelisfun create Dynamic Range For VLOOKUP and Data Validation using the OFFSET and INDEX functions. WORKBOOKS

### Dueling Excel 74

April 20, 2016

Dynamic Range For VLOOKUP & Data Validation List – Table Feature DESCRIPTION See Mr Excel and excelisfun use the Excel Table Feature to create dynamic ranges for Data Validation List and VLOOKUP function. WORKBOOKS

### Dueling Excel 71

March 30, 2016

ROUND to 4 or 2 Formula or Conditional Formatting? DESCRIPTION See Mr Excel and excelisfun round numbers to 2 if the column says “DOLLAR” and 4 if the column says “CRUDE” using the functions ROUND, […]

### Excel Magic Trick 1194

February 29, 2016

VLOOKUP: Data Mismatch Makes Yields #N/A, What To Do? DESCRIPTION See how convert Number lookup_value to Text Number and how to convert Text Number lookup_value to Number to VLOOKUP does not yield #N/A: (00:08) Problem […]

### Excel Magic Trick 1191

February 8, 2016

VLOOKUP: Lookup Temperature and Return to Bat Observation Table DESCRIPTION In this example we have Date Set 1 with Bat Observation Date-Times and we need to lookup the Date-Time in a second Data Set with […]

### Dueling Excel 58

January 6, 2016

Sorting Formula For Biggest Sales and Sales Rep Names with Ties DESCRIPTION See Mr Excel and excelisfun create formulas for sorting biggest to smallest (descending) numbers that can deal with ties, then sort the sales […]