Excel Forum
Similar Content
Sort Data Alphabetically or Numerically in Excel 2007 and Later
Tutorial: This Excel tip shows you how to Sort Data Alphabetically and Numerically in Excel 2007. T...
Formula to Get Value of Last Non-Empty Cell in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel....
Formula to Count Occurrences of a Word in a Cell or Range in Excel
Tutorial: Formula to count how many times a word appears in a single cell or an entire range in Exce...

Excel Magic Trick 765: Formula To Sort Top 3, Including Ties

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to create a series of formulas that will Sort Top 3 values and the record associated with the top three values, Including Ties. See the functions COUNTIF, LARGE, IF, ROW, ROWS, N, INDEX, SMALL. Trick from Aladin at the Mr Excel Message Board.

Got a Question? Ask it Here in the Forum.