Rank using data in 3 columns

[JV0710]

Good day . . . Please anyone help me with modifying this formula

=RANK(I2,I$2:I$51)+ SUMPRODUCT(--(I$2:I$51=I2),--(J$2:J$51>J2)) - copied down

This formula ranks column I and when there are duplicate values in column I it goes to column J and uses the data in column J to rank the duplicates in column I - so that there are no duplicate rankings

I now would like to use a third column ( column K ) as I also have duplicate values in column J

How do I edit the formula to include the data in column K

I have tried: =RANK(I2,I$2:I$51)+ SUMPRODUCT(--(I$2:I$51=I2),--(J$2:J$51>J2),--(K$2:K$51>k2)) but it does not work and gives me duplicate rankings

Thanks in advance

Joe

 

[JV0710]

Hi All

I have worked out an interim solution - I added column J & K and then used the original formula that I had - This works for this spreadsheet.

 

[InaCell]

Have a look at this thread. http://www.mrexcel.com/forum/excel-questions/728066-tournament-scoring-problem.html

 

[Snakehips]

JV0710,

You could try...

Excel 2007
	I	J	K	L	M
1					Rank
2	2				8
3	1				9
4	4				7
5	7				5
6	5				6
7	8	3	4		3
8	8	3	5		2
9	8	3	2		4
10	55				1
Sheet9

Cell Formulas
Range	Formula
M2	=RANK(I2,I$2:I$51)+ SUMPRODUCT(--(I$2:I$51=I2),--(J$2:J$51>J2))+ SUMPRODUCT(--(J$2:J$51=J2),--(K$2:K$51>K2))

 

[JV0710]

Thanks for the help guys