Rank Table in descending order

**Merv** · 12-15-2009, 01:25 PM

Hi,
I am looking to create a seperate league table based on percentages in two tables in descending order.
What i want is the not ready times in one ranked table and the call logging in another along with the persons name and percentage.
Im stumped about what is the simplest way to do this.

See attach for the data.

Thanks,
Merv.

**JBeaucaire** · 12-15-2009, 02:28 PM

Your example sheet does not include a mockup of your desired results based on the data. It should, just make sure we aren't interpreting your goal incorrectly.

**JBeaucaire** · 12-15-2009, 02:43 PM

Perhaps something like this. I've added a ranking formula beside each table. Tie-breaking for same values is resolved by "placement" in the table...so the higher up in the table you are, you get the higher ranking...sort of seniority.

Then a table is created to the right from the rankings.

**Merv** · 12-16-2009, 05:09 AM

thanks great, pretty much what i was looking, but what would i add to the formula for not reay times so that it goes in ascending order?

**JBeaucaire** · 12-16-2009, 01:33 PM

The RANK() formula does descending by default. There is an optional third parameter you can add to make it rank ascending instead, like golf scores.

In I5:
=RANK(H5, $H$5:$H$33, 1) + COUNTIF($I$4:I4, RANK(H5, $H$5:$H$33, 1))

I also changed the percentage columns in the results tables so they will work whether you sort ascending or sort descending.

**Merv** · 12-17-2009, 10:18 AM

Cheers thanks for that mate.

**JBeaucaire** · 12-17-2009, 01:22 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)