Excel Is Fun

Excel Magic Trick 1314

August 17, 2017 0

DESCRIPTION See Excel Formula To Create Sorted Unique List On Mixed Data: (00:08) Problem set up (01:26) Essential logical behind Sorting Formula (04:38) Unique Count Formula For Mixed Data (08:27) Formula to Extract a Sorted […]

Excel Is Fun

Excel Magic Trick 1313

August 14, 2017 0

DESCRIPTION Learn how to create an Array Formula to Create Sorted Unique List in Cell. This is a huge complicated formula that requires the Excel 2016 function TEXTJOIN. There are many interesting formula elements in […]

Excel Is Fun

Excel Magic Trick 1312

August 10, 2017 0

DESCRIPTION Learn: (00:08) Problem introduction. (00:33) How to use NETWORKDAYS.INTL to count the number of working days between a start and end date. NETWORKDAYS.INTL is in Excel 2010 or later versions. (01:46) Formula to count […]

Excel Is Fun

Excel Magic Trick 1311

August 7, 2017 0

DESCRIPTION See an Array Formula that can extract (from a proper data set) multiple invoice items for one lookup value & show total. See the functions: COUNTIFS, ROW, AGGREGATE, ROWS, INDEX, IF and SUMIFS. See […]

Excel Is Fun

Excel Magic Trick 1310

August 3, 2017 0

DESCRIPTION Calculate Minimum Value Greater Than Zero. See the functions: SMALL, COUNTIFS and AGGREGATE (LARGE). WORKBOOKS

Excel Is Fun

Excel Magic Trick 1309

July 31, 2017 0

DESCRIPTION Learn how to create an array formula to display a unique list in a single cell. This formula comes from Bill Szysz at YouTube. See the functions: MATCH, ROW, IF and the new Excel […]

Excel Is Fun

Excel Magic Trick 1308

July 27, 2017 0

DESCRIPTION Learn how to Concatenate Items in Rows & Columns from Two-Way Table with TEXTJOIN (New Excel 2016 Function). WORKBOOKS

Excel Is Fun

Excel Magic Trick 1307

July 24, 2017 0

DESCRIPTION Create Logical Formula to conditionally format only certain cell sin cross tabulated report using a Boolean Array Operation inside the SUM function: (00:13) Problem Set Up (01:25) Look at Logical Formula using AND and […]

Excel Is Fun

Excel Magic Trick 1306

July 20, 2017 0

DESCRIPTION Learn how to create a formula that simulates a relationship between two tables (like a VLOOKUP Helper Column) to create a Regional Report. See array formula where we see VLOOKUP function and Exact Match […]

Excel Is Fun

Excel Magic Trick 1305

July 17, 2017 0

DESCRIPTION Learn how to perform multiple two-way lookups for a cross tabulated table to get multiple sales numbers and then add them using an array formula. Learn how to get INDEX function to deliver an […]