Sorting in Excel using Ranking and sumproduct

[abadilala]

I want to create the ranking based on 3 columns without sorting method. How can I make this in excel? I saw people using rank and sumproduct, but can you teach me?

https://imgur.com/kG5eVlF

 

[oldbrewer]

if you define how you rank eg max total score, or are the scores weighted ?

 

[oldbrewer]

	test1	test2	test3	rank				helper		helper	helper		NAME	RANK	if duplicates
name1	11	19	13	4				43	1	43	52.00000009		name8	1	1
name2	16	10	13	6				39	2	39	52.00000004		name3	2	1
name3	17	15	20	1				52	3	52	46.00000011		name10	3	3
name4	13	1	17	9				31	4	31	43.00000012		name11	4	4
name5	6	3	14	12				23	5	23	43.00000002		name1	5	4
name6	4	3	10	14				17	6	17	39.00000008		name7	6	6
name7	14	10	15	6				39	7	39	39.00000003		name2	7	6
name8	20	15	17	1				52	8	52	37.00000013		name12	8	8
name9	1	1	1	15				3	9	3	31.00000016		name15	9	9
name10	19	8	19	3				46	10	46	31.00000005		name4	10	9
name11	17	12	14	4				43	11	43	27.00000015		name14	11	11
name12	12	8	17	8				37	12	37	23.00000006		name5	12	12
name13	16	3	1	13				20	13	20	20.00000014		name13	13	13
name14	15	4	8	11				27	14	27	17.00000007		name6	14	14
name15	10	20	1	9				31	15	31	3.0000001		name9	15	15
	so you can have rank against name in name order or the names in rank order
	note tat 2 scores of 52 are each ranked 1 and the next score of 46 is ranked 3

<colgroup><col span="11"><col><col span="6"></colgroup><tbody>
</tbody>