Excel Magic Trick 1321

Time Between Starting College & Taking 1st Geology Class (6 Methods)

DESCRIPTION

See how to use
(00:14) Intro
(01:36) MIN & MAX & IF & SEARCH solution (Any Version of Excel)
(07:49) INDEX & MATCH & LEFT solution (Any Version of Excel)
(08:35) AGGREGATE & ISNUMBER & SEARCH solution (Excel 2010 or later)
(13:03) MAXIFS & MINIFS solution (Excel 2016 Insider Program or later versions of Excel)
(15:58) 2 PivotTables and a Formula solution (Any Version of Excel)
(20:08) Power Query solution (Excel 2016, or as Download in Excel 2010 or 2013)

WORKBOOKS

Download “Excel Magic Trick 1321-1340” Excel-Magic-Trick-1321-1340.zip – Downloaded 259 times – 98 MB




Be the first to comment

Leave a Reply