Tiebreaker for the Rank function?

I didn't know there was an Excel version 2014?

Try one of these...

For lowest to highest:

=RANK.AVG(A1,A$1:A$10,1)

For highest to lowest:

=RANK.AVG(A1,A$1:A$10)

Assuming data set is in A1:A6
In B1:
=RANK(A1,$A$1:$A$6)
In B2 and drag down
=RANK(A2,$A$1:$A$6)+COUNTIF($B$1:B1,RANK(A2,$A$1:$A$6))/2

Ok, you'll need Excel 2010 or later for that formula.

I'm having second thoughts as whether that's the correct formula for what you want to do.

Let's try this...

Show us what results you expect for the sample data below:

Data Range

	A	B
1	Value	Rank
2	10
3	10
4	7
5	6
6	6
7	6
8	4
9	4
10	2
11	1

untitled.PNG

This is what it would look like.

Here is the actual document I am trying to do this with. I entered in the desired values into where they would be with the mystery formula.

https://docs.google.com/spreadsheets...it?usp=sharing

Data Range

	A	B
1	Value	Rank
2	10	4.5
3	10	4.5
4	7	4
5	6	3.5
6	6	3.5
7	6	3.5
8	4	2.5
9	4	2.5
10	2	2
11	1	1

I don't understand the logic in those ranks. Can you explain how you arrive at those results?

Originally Posted by Tony Valko

Data Range

	A	B
1	Value	Rank
2	10	4.5
3	10	4.5
4	7	4
5	6	3.5
6	6	3.5
7	6	3.5
8	4	2.5
9	4	2.5
10	2	2
11	1	1

I don't understand the logic in those ranks. Can you explain how you arrive at those results?

It's actually a way of ranking used in Statistics workflows.

I actually think I have been telling you wrong. I apologize for that. Okay, here is the logic:

When there is a tie between two numbers (5 and 6 for example), it defaults to the mean of those two ranks (5.5) It then would continue to 7,8,9,etc. Example:Capture.PNG



Again, sorry for completely saying the wrong thing before. I'm actually doing this to make the workflow of my Statistics assignments less terrible.

Good deal. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.