Dueling Excel

Dueling Excel 124

January 11, 2017 0

DESCRIPTION Dynamic Stacked Line Chart See Mr Excel and excelisfun use two methods to lookup a column based on a date and then add all the values for the North Region 1. NA error Trick […]

Dueling Excel

Dueling Excel 123

January 4, 2017 0

DESCRIPTION Lookup Column and then Add With Criteria See Mr Excel and excelisfun use two methods to lookup a column based on a date and then add all the values for the North Region 1. […]

Dueling Excel

Dueling Excel 122

December 7, 2016 0

DESCRIPTION Entering Credit Card Numbers With More Than 15 Digits See Mr Excel and excelisfun use two methods to: 1. Text Number Formatting 2. Custom Number Formatting 3. Lead Apostrophe WORKBOOKS

Dueling Excel

Dueling Excel 121

November 30, 2016 0

DESCRIPTION MIN and MAX Between Two Dates For Each Region See Mr Excel and excelisfun use two methods to calculate MIN and MAX Between Two Dates For Each Region (Minimum value and maximum value with […]

Dueling Excel

Dueling Excel 120

November 23, 2016 0

DESCRIPTION Summarize By Week and Month, Monthly Totals, Weekly Totals See Mr Excel and excelisfun use two methods to Summarize By Week and Month: 1. See two methods that use SUMIFS, EOMONTH, WEEKDAY and other […]

Dueling Excel

Dueling Excel 119

November 16, 2016 0

DESCRIPTION Sorting For Plant List, Sort by Month and Day Only See Mr Excel and excelisfun use two methods to override the Sort feature’s default Date sorting technique so that we can sort just by […]

Dueling Excel

Dueling Excel 118

November 9, 2016 0

DESCRIPTION Formula To Calculate Commissions for Four Scenarios See Mr Excel and excelisfun use two methods to calculate the commissions based on the fact that the two sales people may both be at work for […]

Dueling Excel

Dueling Excel 117

November 2, 2016 0

DESCRIPTION Extract Top Five Numbers See Mr Excel and excelisfun use two methods to extract top five numbers: UDF VBA or formula WORKBOOKS

Dueling Excel

Dueling Excel 116

October 26, 2016 0

Extract Individual Letters From Cell and do Lookup Adding, then… DESCRIPTION See Mr Excel and excelisfun use two methods to do lookup adding from a cell and then show one of three categories: ‘Under Zero”, […]

Dueling Excel

Dueling Excel 115

October 21, 2016 0

Plot Chart, Show Only Selected Employee Name Is Axis DESCRIPTION See Mr Excel and excelisfun use two methods to plot all the sales for all the employees, but show only the employee name of selected […]