excelisfun Flashback Friday 05: Extract Top 5 Values & Names with Array Formula

Описание: excelisfun Flashback Friday 05: Extract Top 5 Values & Names with Array Formula
Download Excel File: https://people.highline.edu/mgirvin/Y...
Learn how to create the classic Array Formula to extract the top five values with names including when there are ties. See the Functions: INDEX, MATCH, COUNTIFS, AGGREGATE, SMALL, ROW, ROWS, IF Function and more. This is an excelisfun YouTube Channel Flashback Friday back to a video that I made in 2012.