Dueling Excel

Dueling Excel 007

January 17, 2015 0

DESCRIPTION See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table and then retrieve Column and Row header. Mr Excel uses Excel VBA code (Macro) excelisfun uses a formula with INDEX, IF, […]

Excel Is Fun

Excel Magic Trick 1091

January 16, 2015 0

Count Number of Items In Row For First Occurrence of Each Group DESCRIPTION See how to count the number of items entered into the row that corresponds to the first occurrence of each Group Number […]

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

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