Breaking Tiebreakers

Row\Col	A	B	C	D	E	F	G
1	Picks	Pct	Player	Helper	Rank
2	5	15	A	5.15	4		D2 and down: =A2+B2/100
3	10	10	B	10.10	1		E2 and down: =RANK(D2, $D$2:$D$7)
4	6	9	C	6.09	2
5	3	5	D	3.05	6
6	4	20	E	4.20	5
7	5	19	F	5.19	3

Or try this without a helper...
=RANK(A2,$A$2:$A$7)+COUNTIF(A$2:A2,A2)-1
copied down

Are these the results you're wanting?

Data Range

	A	B	C	D
1	Right picks	Percentage	Player	Rank
2	5	15	A	4
3	10	10	B	1
4	6	9	C	2
5	3	5	D	6
6	4	20	E	5
7	5	19	F	3

This formula entered in D2 and copied down:

=RANK(A2,A$2:A$7)+SUMPRODUCT(--(A2=A$2:A$7),--(B2<B$2:B$7))

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit - and often dont even show up on the forum, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

Sorry, I can't see your images.

Try this...

Data Range

	A	B	C	D	E
2			Correct	Attempts	Percentage
3	1	Joey	11	42	26.1904762
4	2	Charlie	11	47	23.4042553
5	6	Alex	5	49	10.2040816
6	3	Joe	7	41	17.0731707
7	5	Brandon	5	38	13.1578947
8	4	Brian	6	48	12.5
9	7	Dom	4	38	10.5263158
10
11	STANDINGS
12	1	Joey	11	26.1904762
13	2	Charlie	11	23.4042553
14	3	Joe	7	17.0731707
15	4	Brian	6	12.5
16	5	Brandon	5	13.1578947
17	6	Alex	5	10.2040816
18	7	Dom	4	10.5263158

This formula entered in A3:

=RANK(C3,C$3:C$9)+SUMPRODUCT(--(C3=C$3:C$9),--(E3<E$3:E$9))

Copy down to A9.

You're welcome. We appreciate 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.