Extracting the top 5 maximum values in excel

by

Given a data setup like this:

Top 5 by criteria

The formula in cell D2 and copied down is:

=INDEX($B$2:$B$28,MATCH(1,INDEX(($A$2:$A$28=LARGE($A$2:$A$28,ROWS(D$1:D1)))*(COUNTIF(D$1:D1,$B$2:$B$28)=0),),0))

This formula will work even if there are tied OPS scores among players.

More Related Contents:

  1. Save excel file multiple times with file names in another workbook.
  2. Is it possible to force Excel recognize UTF-8 CSV files automatically?
  3. Read/Parse text file line by line in VBA
  4. How do I find the last column with data?
  5. Excel VBA: Answer gets “stuck”
  6. How to insert a picture into Excel at a specified cell position with VBA
  7. Save multiple sheets to .pdf
  8. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  9. filter out multiple criteria using excel vba
  10. Excel VBA autofilter all but three
  11. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  12. Generating CSV file for Excel, how to have a newline inside a value
  13. Ignore Duplicates and Create New List of Unique Values in Excel
  14. Excel VBA code to copy a specific string to clipboard
  15. Merge values of column B based on common values on column A
  16. Delete a row in Excel VBA
  17. Two column lookup in table array using INDEX and MATCH
  18. Concatenate cell data into another data if values matches
  19. What charset does Microsoft Excel use when saving files?
  20. How can I run VBA code each time a cell gets its value changed by a formula?
  21. How to convert 32 bit VBA code into 64 bit VBA code
  22. Creating a chart in Excel that ignores #N/A or blank cells
  23. Countif With Multiple OR Criteria
  24. Vlookup to copy color of a cell
  25. every possible combination of the contents of 2 columns in excel
  26. How to delete rows in Excel based on criteria using VBA?
  27. Macro to export MS Word tables to Excel sheets
  28. excel vlookup with multiple results
  29. How to protect Excel workbook using VBA?
  30. Unique Rank value for a subgroup within a group

Leave a Comment