Excel Forum

Excel Magic Trick # 273: Extract Top 5 Records w Formula

Extract top (max high) 5 records w formula where duplicates are allowed. See how to extract the top (max high) five values and associated names from a database with an array formula that can handle duplicate top values. See the functions: TRANSPOSE, COUNTIF, MAX, INDIRECT, IF, COLUMNS, INDEX, SMALL and ROW in an array formula.

Reverse lookup. INDEX function with criteria conditions.

Got a Question? Ask it Here in the Forum.