Dueling Excel

Dueling Excel 133

March 15, 2017 0

DESCRIPTION See Mr Excel and excelisfun use two methods to sum the three biggest values that match three criteria (3 conditions) 1. Advanced Filter and LARGE and MAX value 2. SUM and LARGE functions with […]

Dueling Excel

Dueling Excel 132

March 8, 2017 0

DESCRIPTION See Mr Excel and excelisfun use two methods to convert from the numbers 10.1 and 10.2 to 10.333 and 10.667, and the reverse using two methods: 1. DOLLARDE and DOLLARFR functions 2. MOD and […]

Dueling Excel

Dueling Excel 131

March 1, 2017 0

DESCRIPTION See Mr Excel and excelisfun use two methods to Prevent VLOOKUP from Returning a Zero: 1. Alter the lookup table so there are not empty cells 2. Custom Number Formatting 3. IF and VLOOKUP […]

Dueling Excel

Dueling Excel 130

February 22, 2017 0

DESCRIPTION Text Formula To Show Calculation (Not Formula) From A Cell See Mr Excel and excelisfun use two methods to show formula calculation in a cell: 1. Use Ampersand (Join Symbol), Text in Double Quotes, […]

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