Hi,
Relatively new to excel and wondered if someone could help with the Rank Function, please. I have 6 numbers which I have managed to order using the rank function. But if two items are the same and therefore return the same rank (equal first for example), I want to count them as a half each (three items a third each etc.) Any help would be appreciated. Thanks.
So...How would you want these values ranked?
10
20
20
30
30
30
30
40
Have you tried RANK.AVG function?
That will average equal ranks so if you have 3 tied for 1st they are ranked 2 - (1+2+3)/3
Audere est facere
To explain a bit more fully, I'm ranking Sports teams so if the results were as follows:
Team A 1st
B 2nd
C 3rd
D 4th
E 5th
F 6th
I want to add 1 to team A's total. If the results are as follows:
A =1st
B =1st
C =1st
D 4th
E 5th
F 6th
I want teams A,B and C to get a third of a point each.
Only first places, or teams tied for first, are noted - the lower positions aren't important.
Thanks.
With these values in A1:B6
This regular formula, copied down, allocated items ranked 1 amongst the members:
Please Login or Register to view this content.
In that example, these are the returned values:Please Login or Register to view this content.
Is that something you can work with?Please Login or Register to view this content.
Thanks Ron, I'll give that a try.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks