Excel Is Fun

Excel Magic Trick 1220

August 11, 2016 0

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

Excel Is Fun

Highline Excel 2016 Class 02

July 24, 2016 0

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

Dueling Excel 86

July 13, 2016 0

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

Dueling Excel 81

June 8, 2016 0

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

Dueling Excel 75

April 27, 2016 0

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

Dueling Excel 74

April 20, 2016 0

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

Dueling Excel 71

March 30, 2016 0

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 Is Fun

Excel Magic Trick 1194

February 29, 2016 0

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 Is Fun

Excel Magic Trick 1191

February 8, 2016 0

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

Dueling Excel 58

January 6, 2016 0

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