Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727.

Posted on by Bb

Download Excel File: https://excelisfun.net/files/EMT1727.xlsx
See three formulas to lookup nth value:
1. (00:00) Introduction
2. (00:32) Formula #1: Microsoft 365 with INDEX and FILTER functions.
3. (01:31) Formula #2: Excel 2010 or later: AGGREGATE, ROW and INDEX functions.
4. (03:47) Ctrl + C, C copy trick.
5. (04:10) Formula #3: Any version of Excel: SMALL, IF, ROW and INDEX functions.
6. (05:13) Summary, Closing and Video Links

ExcelIsFunTue, August 10, 2021 12:09am