|
Featured Tutorial
Featured Macro
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.
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.