Dueling Excel 58


Sorting Formula For Biggest Sales and Sales Rep Names with Ties

DESCRIPTION

See Mr Excel and 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, INDEX, SMALL, IF, ROW function in formulas and array formulas.

WORKBOOKS




Be the first to comment

Leave a Reply