This is what I use to track the top 5 absentees…
Edit to suit your needs.
Formula in cell A1:
=INDEX(A$13:A52,AGGREGATE(15,6,ROW($1:$40)/(B$13:B$52=B1),COUNTIF(B$1:B1,B1)))
Formula in cell B1:
LARGE(B$13:B$52,ROW())
More Related Contents:
- Want to concatenate multiple row data in in cell along with its values if present. Emp Id should not come if no data available infromt of it
- How to convert to percentage [closed]
- Excel Number Separation [closed]
- I have an Excel data sheet that I would like to extract data from into a new sheet
- Getting unique values in Excel by using formulas only
- Return empty cell from formula in Excel
- Excel: last character/string match in a string
- Referencing value in a closed Excel workbook using INDIRECT?
- Simple Pivot Table to Count Unique Values
- How can I perform a reverse string search in Excel without using VBA?
- Excel UNIQUE Across Columns
- Filling any empty cells with the value above
- How to create a string or formula containing double quotes in Excel?
- Find last used cell in Excel VBA
- Remove leading or trailing spaces in an entire column of data
- Excel Date to String conversion
- Excel: Formulas for converting data among column / row / matrix
- Excel: Searching for multiple terms in a cell
- Three Dimensional Lookup Using INDEX/MATCH
- Optimizing Excel formulas – SUMPRODUCT vs SUMIFS/COUNTIFS
- How to split texts from dynamic range?
- Excel: Search for a list of strings within a particular string using array formulas?
- Convert from US to UK format
- excel vlookup with multiple results
- How to roundup a number to the closest ten?
- Convert an Array Formula’s Text Results into a Usable Format
- Date-Formatting in TEXT formula independent from used language in Excel
- Can’t pass a range to a lambda using Let and Makearray functions
- Check whether a cell contains a substring
- Unique Rank value for a subgroup within a group