Dueling Excel

Dueling Excel 129

February 15, 2017 0

DESCRIPTION Dynamic Range Last Ten Numbers Column: OFFSET or INDEX Formula? See Mr Excel and excelisfun use two methods to create Dynamic Range For Last Ten Numbers in Coulmn: 1. OFFSET function to create dynamic […]

Dueling Excel

Dueling Excel 128

February 8, 2017 0

DESCRIPTION Count Occurrences Of Items: PivotTable Or Advanced Filter & COUNTIF See Mr Excel and excelisfun use two methods to count the occurrences of items in a list: 1. PivotTable 2. Advanced Filter Extract Unique […]

Dueling Excel

Dueling Excel 127

February 1, 2017 0

DESCRIPTION Adding After & Before Dash: Array Formula or VBA? See Mr Excel and excelisfun use two methods to solve this very difficult adding problem: you must add numbers from a column of text strings […]

Dueling Excel

Dueling Excel 126

January 25, 2017 0

DESCRIPTION SUM Daily Totals from Text Dates with Text Day Criteria See Mr Excel and excelisfun use two methods to 1. Add up daily sales from a template that is not setup properly: multiple columns […]

Dueling Excel

Dueling Excel 125

January 18, 2017 0

DESCRIPTION Conditional Formatting Date Four Days Old & Not Paid See Mr Excel and excelisfun use two methods to Conditional Formatting Date That is Four Or More Days Old & Not Paid 1. Conditional Formatting […]

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