Dueling Excel

Dueling Excel 016

DESCRIPTION See Mr Excel and excel is fun create scroll bars that will control a percentage in a cell. Mr Excel will do an ActiveX Control and excelisfun will do a Form Control. WORKBOOKS

Dueling Excel

Dueling Excel 015

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 [Read More >>>]

Dueling Excel

Dueling Excel 014

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 [Read More >>>]

Dueling Excel

Dueling Excel 013

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 [Read More >>>]

Dueling Excel

Dueling Excel 012

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

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, [Read More >>>]

Dueling Excel

Dueling Excel 010

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 [Read More >>>]

Dueling Excel

Dueling Excel 009

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 [Read More >>>]

Dueling Excel

Dueling Excel 008

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 [Read More >>>]

Dueling Excel

Dueling Excel 007

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, [Read More >>>]