Rank then sort

Hi Team,

First post - hopefully I'll give you all the info you need and someone is able to assist...

I have 8 sales people. I gather different results and have created a spreadsheet that will rank 8 people based on results in 7 different categories.

So no problems so far - I have created the Rank formula and it displays the correct positions.

What I'd like to do now is sort the results so instead of having..

John 8
Bev 1
Chris 2
David 3
bob 6
gina 5
Kelly 4
ann 7

I'd like ..

Bev 1
Chris 2
David 3
Kelly 4
Gina 5
Bob 6
Ann 7
John 8


Any assistance greatly appreciated.

Thanks

You'll need the rank in a separate column; probably you do already. Select the block. Then it depends on your excel version, but the menu will have something like Data at the top, then sort in the dropdown. Sort on the seond column.

Thanks for reply -

I've tried that - it doesn't work.

(Yes the names and the calculate rank are in different cells)

Here is desensitized file RANKING HELP.xlsm

Thank you!!!

I love the filter on the table . . . now I need to learn how to make this happen!

Would you be able to assist further?

So I'd like to input the data to the top table.
That would 'filter' the weekly rankings and also when I click the macros button update the period ranking.

Is the filter something that updates automatically as I type in the top table or do I need to create a macros for it to run and adjust ranking.

I guess the weekly ranking and the period ranking are then not required as the team will be ranked according to the score (lowest first)

I'd like to learn how to do this, any help appreciated.

Ultimately, its all about just putting in the data and the rankings appear by themselves.

Thanks again!

I went one week further and put in the data for week 3...

File attached - the filter and sort on the period table, creates an error. Whomever is on the top line gets their points instead of the points for the week being allocated to the correct person.

OK I'll have a look at that and post a spreadsheet in a few days that will reflect my attempt!

Thanks again