Dueling Excel

Dueling Excel 025

May 27, 2015 0

Extract Records NOT Swim or Ski (Filter or Formula?) DESCRIPTION See Mr Excel and excelisfun extract records from database that are NOT Swim or Ski with Filter, Advanced Filter, or Formula using ISNUMBER, LOOKUP and […]

Dueling Excel

Dueling Excel 019

March 19, 2015 0

DESCRIPTION See Mr Excel and excel is fun try to use VLOOKUP to the left. Mr Excel shows how to use INDEX & MATCH to solve this problem. Excelisfun will use the LOOKUP function to […]

Excel Is Fun

Excel Magic Trick 1104

March 2, 2015 0

DESCRIPTION See how to add unit numbers with AND and OR Criteria where the criteria are given as years and months but date column contains serial number dates. See how to use SUMIFS function to […]

Excel Is Fun

Excel Magic Trick 1103

March 1, 2015 0

DESCRIPTION Formulas for Quarters, Fiscal Quarters & Fiscal Years: (00:07) Quarters using CEILING and MONTH function (02:48) Fiscal Quarter using LOOKUP and MONTH (05:24) Fiscal Quarter using IF, MONTH and CEILING (06:40) Fiscal Year using […]

Dueling Excel

Dueling Excel 006

January 15, 2015 0

DESCRIPTION See Mr Excel and excelisfun try and retrieve the last value in a row. See the INDEX, OFFSET, LOOKUP and MAX functions. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1086

January 10, 2015 0

DESCRIPTION 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch & Merged Cell Trouble See how to:  (00:11 min) Create formula to lookup a value from a table with three criteria: INDEX and MATCH and […]

Excel Is Fun

Excel Magic Trick 1085

January 9, 2015 0

DESCRIPTION What if you are not allowed to have a helper columns to lookup Price and Region with VLOOKUP? And you need to calculate Total Revenue by Region? This video shows how to create a […]

Dueling Excel

Dueling Excel 001

January 2, 2015 0

DESCRIPTION See Mr Excel and excelisfun demonstrate two methods to do a two way lookup on a table array: Mr Excel: MATCH and INDEX functions in one formula to retrieve a value from the intersection […]