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.