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.