Excel Forum
Similar Content
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...
Make Complex Formulas for Conditional Formatting in Excel
Tutorial: How to make complex formulas for conditional formatting rules in Excel. This will serve as...
Sparkling Christmas Tree in Excel
Tutorial: How to make a wonderful sparkling Christmas tree in Excel. This method uses only formulas;...



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.