Excel Is Fun

Excel Magic Trick 1113

March 11, 2015 0

DESCRIPTION 1. Text To Columns using Fixed Width, One Time Event 2. Formula that will update when data changes. Formula uses MID and COLUMNS functions and Mixed Cell References. WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 20

February 19, 2015 0

DESCRIPTION Topics in this video: (00:15) VLOOKUP to retrieve whole record change columns manually. (02:20) VLOOKUP to retrieve whole record column number in cell. (03:43) VLOOKUP & MATCH to retrieve whole record — more dynamic […]

Dueling Excel

Dueling Excel 010

January 20, 2015 1

DESCRIPTION See Mr Excel and excelisfun invert a range (Turn a range of cells upside down) with two different INDEX formulas. See the functions: INDEX ROW, ROWS, COLUMNS. See how to flip range 180 degrees […]

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