Excel Forum



Mr Excel & excelisfun Trick 58.5: Sorting Formula For Biggest Sales and Sales Rep Names with Ties


See excelisfun create formulas for sorting biggest to smallest (descending) numbers that can deal with ties, then sort the sales representative names also. See the functions: VLOOKUP, COUNTIF, RANK, LARGE and ROWS in formulas.





Got a Question? Ask it Here in the Forum.