Excel Magic Trick 1271

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 when there are duplicates and Power Query:
(00:01) Microsoft Data Insights Summit
(00:17) Introduction to video topics
(01:43) Formula Method when there are no duplicates. See the functions: LARGE, INDEX and MATCH
(06:18) Array Formula for when there are duplicate values. See the functions: LARGE, INDEX, AGGREGATE, ROW and COUNTIFS.
(13:48) Power Query Method

WORKBOOKS