Ranking data

[6626ben]

Version: 2008 I have a list of data in a table that I wish to rank, I'm familiar with the RANK formula and can successfully use it, but many of the numbers in the field by which I am ranking are the same. I want to be able to rank the 'teams' first by 'points' but then alphabetically if they have the same points total. Is this possible? Please Help!

 

[CyberTaz]

Are you looking to 'rank' the listings or *sort* the list? It sounds like
the latter. If that's the case, go to Data> Sort then select 'points' as the
first sort key & 'team' as the second.

AFAIK RANK() only evaluates numbers, not text, & only looks at one range of
values.

 

[6626ben]

I'm looking to rank them, so it isn't possible to have two references in RANK if one of them is text? damn. This is very annoying! Thanks for the help though.
Ben

 

[CyberTaz]

Pardon my ignorance, but how would you expect to 'rank' teams on the basis
of their names?

It seems to me that *points* alone would determine the ranking & that teams
would simply need to be listed in alpha order within any rank shared by 2 or
more teams, no?

 

[John_McGhie_[MVP]]

Sort by Column A (points) then by Column B (Names).

The Data>Sort command will sort by up to three concurrent criteria.

Cheers

Version: 2008 I have a list of data in a table that I wish to rank, I'm
familiar with the RANK formula and can successfully use it, but many of the
numbers in the field by which I am ranking are the same. I want to be able to
rank the 'teams' first by 'points' but then alphabetically if they have the
same points total. Is this possible? Please Help!

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]