|
Featured Tutorial
Featured Macro
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.
Reverse lookup. INDEX function with criteria conditions.