Dueling Excel

Dueling Excel 015

February 26, 2015 0

DESCRIPTION See Mr Excel use a Pivot Table with Grouping and a Count function to create a Frequency Distribution. See excel is fun use the FREQUENCY function (upper limit is included in count) to create […]

Dueling Excel

Dueling Excel 014

February 25, 2015 0

DESCRIPTION See Mr Excel and excelisfun create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers. See functions like: SIGN, IF, and […]

Dueling Excel

Dueling Excel 013

February 24, 2015 0

DESCRIPTION See Mr Excel and excelisfun create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set. See the functions SUM, COUNTIF, AVERAGE / IF array formula and the AVERAGEIF new […]

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 011

February 22, 2015 0

DESCRIPTION See Mr Excel and excelisfun create a formula that will randomly select a name from a list of names without having the list of names sitting in cells. See the functions INDEX, RANDBETWEEN, INT, […]

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 009

January 19, 2015 0

DESCRIPTION See Mr Excel and excelisfun take a table of data and create a column of values that can be used with the Statistical Data Analysis Excel Add-in. Mr Excel uses VBA Macro code. excelisfun […]

Dueling Excel

Dueling Excel 008

January 18, 2015 0

DESCRIPTION See Mr Excel and excelisfun try to deal with the Top 10 Filter with Two Criteria Trouble. Mr Excel solves the problem with Advanced Filter and a Criteria Formulas. Excelisfun solves the problem with […]

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

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