### Excel Magic Trick 1220

August 11, 2016

How To Put Double Quotes In Text Formula: Extra Double Quotes Or VLOOKUP DESCRIPTION Learn how to either use IF function and Extra Double Quotes or VLOOKUP to put the text 5’6” or 6’ into […]

### Dueling Excel 89

July 29, 2016

PivotTables Grand Totals To Left: LOOKUP or GETPIVOTDATA function? DESCRIPTION See Mr Excel and excelisfun use two methods to shows PivotTable Grand Totals to the left of the PivotTable (Since there is no way to […]

### Highline Excel 2016 Class 02

July 24, 2016

Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excel’s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text […]

### Dueling Excel 86

July 13, 2016

MODE or MEDIAN From Frequency Table Formula or VBA? DESCRIPTION See Mr Excel and excelisfun use two methods calculate MODE or MEDIAN From Frequency Table – Formula or VBA. See the functions, AND, COUNTIF, MAX, […]

### Dueling Excel 78

May 18, 2016

Extract Top Two Customers In Each Industry with Formula (2 Examples) DESCRIPTION See Mr Excel and excelisfun Extract Top Two Customers In Each Industry with 2 array Formulas that use the AGGREGATE, IF, COLUMNS, INDEX, […]

### Excel Magic Trick 1200

April 11, 2016

Conditional Format Grades To Assign Icons To 1 of 3 Groups (3 Methods) DESCRIPTION See how to use Conditional Format Grades to assign Stop Light Icons to one of three groups: Green Icons, Yellow Icons […]

### Dueling Excel 71

March 30, 2016

ROUND to 4 or 2 Formula or Conditional Formatting? DESCRIPTION See Mr Excel and excelisfun round numbers to 2 if the column says “DOLLAR” and 4 if the column says “CRUDE” using the functions ROUND, […]

### Excel Magic Trick 1195

March 7, 2016

Are YYMMDD Text Dates 1900 or 2000? Formula or Text To Columns Solution? DESCRIPTION See how to deal with a Text Date in the form YYMMDD when some of the years are 1900 and some […]

### Excel Magic Trick 1193

February 22, 2016

Count Distinct Words As They Are Entered In Column: Formula or Excel Table? DESCRIPTION See how calculate a running count for each unique (distinct) text items entered in column using two methods: (00:10) Problem setup […]

### IF Function

February 14, 2016

IF function Use the IF function to return one value if a condition is true and another value if it’s false. Syntax IF(logical_test, value_if_true, [value_if_false]) example: =IF(A2>B2,“Over Budget”,“OK”) =IF(A4=500,B4-A4,“”) WORKBOOKS