Weekly Team and Individual Leaderboard

danjris

New Member
Joined
Jun 25, 2015
Messages
11
Hello,

I'm lost (per usual) and have searched long enough that I'm starting to go insane so my next step is to post my questions here.

Our sales team is needing/wanting a leader board to not only monitor and display the individual sales but also the team (groups of 4 people) sales.

So every week would be a challenge and at the end of the week a leader board would display all sales people and then one with all 11 team sales.

My first question...If Joe, Bill, and Frank (not Sally) are on Team 1 Can I have a sheet like this:

Name Sales Points Team Total
Joe 1 1 Team 1 6
Sally 2 2
Bill 3 3
Frank 2 2

Also, is there anyway to automatically sort the sheet based on rank? I can get the rank of all sales people but week by week it would be nice to not have to sort (but that's not the hardest thing in the world).

Is there a way to send an entire row to the bottom of a range based on a cell? For instance, if we have sales people who only do online sales they would get bumped below the others.

Example:

Name Sales Points Online?
Joe 1 1 N
Sally 2 2 N
Bill 3 3 N
Frank 2 2 Y

And what's the best way to get the sum and display the overall Team leader board as the weeks go by? I believe each week will be on its own sheet.

I appreciate any and all advice on this one. The most difficult part is probably getting what I want (and what I want to ask) from my brain to right here...so hopefully I made a little sense.

Thanks in advanced!

- Dan
 
Last edited:

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,095,708
Messages
5,446,085
Members
405,379
Latest member
EDGOUG

This Week's Hot Topics

Top