Excel Is Fun

Excel Magic Trick 1200

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

Dueling Excel

Dueling Excel 72

Data Bar Cell Charts in Excel 2007/2010 & Excel 2003 DESCRIPTION See Mr Excel and excelisfun create Data Bar Cell Charts in Excel 2007/2010 using Conditional Formatting & in Excel 2003 using the REPT function. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1199

Formula to Extract Everything After Last Space: Two Formula Solutions DESCRIPTION See how to use Formula to Extract Everything After Last Space: (00:08) Problem Setup (01:05) Formula with TRIM, RIGHT, SUBSTITUTE, REPT, LEN and LEN [Read More >>>]

Dueling Excel

Dueling Excel 71

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

Excel Is Fun

Excel Magic Trick 1198

Median for Each Quarter Using AGGREGATE Function DESCRIPTION See how to calculate Median for Each Quarter Using AGGREGATE Function (00:08) Problem Setup (00:49) Defined Names for ranges using keyboard for Create Names From Selection: Ctrl [Read More >>>]

Dueling Excel

Dueling Excel 70

Lookup & Return Last 5 Numbers in a List DESCRIPTION See Mr Excel and excelisfun create formulas that Lookup & Return Last 5 Items in a List using INDEX and COUNT functions. See a retractable [Read More >>>]

Excel Is Fun

Excel Magic Trick 1197

OR Criteria: Don’t Double Count: DCOUNTA, COUNTIFS, or SUMPRODUCT? DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for each county code, [Read More >>>]