Excel Is Fun

Excel Magic Trick 1271

February 16, 2017 0

DESCRIPTION Extract Top 20 Values & Dates: Formula, Array Formula or Power Query? Learn how to extract Top 20 values and dates for those values using Formulas when there are no duplicates, Array Formula for […]

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

Excel Is Fun

Excel Magic Trick 1259

January 5, 2017 0

DESCRIPTION Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula? Learn how to use two lookup values to lookup an item in a table: (00:11) Problem Introduction and discussion of default behavior for VLOOKUP […]

Excel Is Fun

Excel Magic Trick 1254

December 8, 2016 0

DESCRIPTION Lookup Item Where 2 Values Are Closest: Helper Column or Array Formula? Learn how to create solution to lookup an item where two values are closets in value: (00:10) Problem Introduction (00:36) Helper Column […]

Excel Is Fun

Excel Magic Trick 1236

October 6, 2016 0

DESCRIPTION Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT? Learn how to count numbers that contain the whole number 4: (00:11) Problem Introduction (01:05) COUNTIFS formula that uses Cell References, Comparative Operators and […]

Excel Is Fun

Excel Magic Trick 1227

September 5, 2016 0

DESCRIPTION Conditional Format: Min, Max & Min Value Greater Than Zero Learn how to: (00:12) Problem Introduction (00:38) Conditionally Format the Maximum value in a set of numbers with built in Top 1 Rule (01:32) […]

Excel Is Fun

Excel Magic Trick 1226

September 1, 2016 0

DESCRIPTION Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) Learn how to Compare 2 Lists, Extract Items In List 2 That are NOT in List 1: (00:12) […]

Excel Is Fun

Excel Magic Trick 1224

August 25, 2016 0

Which Similar Array Formula? Compare Number of Array Operations DESCRIPTION Learn how to build similar formulas and compare the number of array operations in order to decide which formula might be most efficient: (00:08) Problem […]

Excel Is Fun

Excel Magic Trick 1222

August 18, 2016 0

Formula To Add 10kg, 6kg, 19kg: Array Formula Or Custom Number Format? DESCRIPTION Learn how to Create a Formula to Add Column Filled With Weights Like: 10kg, 33kg, 19kg: (00:10) Problem Setup (01:12) Customer Number […]