Recognition Program for Top Sales Reps

On today's episode of Call For Help, I discuss a spreadsheet application for recognizing your top sales reps. This could be used daily in a retail store or a car dealership or anywhere with a sales team.

The Excel-Know-How in this tip is how to combine the RANK() function with the VLOOKUP() function to perform a sort using only formulas. This allows you to basically point your formulas to an external copy of an existing sales report and to turn it into a beautiful looking report that you can post in the break room.

See the complete details here.