Excel Is Fun

Excel Magic Trick 1110

March 8, 2015 0

DESCRIPTION See how to compare two lists and extract records with an array formula that uses these functions: MATCH, ISNA, ISNUMBER, IF, ROWS, ROW, INDEX, AGGREGATE and a number of array operations. WORKBOOKS

Dueling Excel

Dueling Excel 012

February 23, 2015 0

DESCRIPTION See Mr Excel and excelisfun create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest. See the functions MAX, LARGE, SMALL, ROW, and ROWS functions. WORKBOOKS

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

Excel Is Fun

Excel Magic Trick 1082

January 1, 2015 2

Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data DESCRIPTION See how to add every other column using 1 or 4 formulas: (00:08 min) Manual method using SUM. See how […]