Excel Forum

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.