How to give different rankings to same values in a column

[sayseee]

How do I rank same values in a column as seen below.

Score	Rank	Needed	Or
6.06	5	4	5
4.85	6	6	6
9.69	2	1	2
6.06	5	5	4
9.69	2	2	1
7.75	3	3	3

Thank you

 

[Sufiyan97]

Try

Book1
	A	B	C	D	E	F
1	Score	Rank	Needed
2	6.06	5	4
3	4.85	6	6
4	9.69	2	1
5	6.06	5	5
6	9.69	2	2
7	7.75	3	3
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=RANK(A2,$A$2:$A$7,0)+COUNTIF($A$2:A2,A2)-1

 

[sayseee]

=RANK(A2,$A$2:$A$7,0)+COUNTIF($A$2:A2,A2)-1

is the one I was trying to use and was not helping.

Strangely this

=RANK(A2,($A$2:$A$7),0)

was able to do the job.

Thank you for your help.

 

[Sufiyan97]

How does it works? it gives same rank

Book1
	A	B	C	D	E
1	Score	Rank	Needed	Or	???
2	6.06	5	4	5	4
3	4.85	6	6	6	6
4	9.69	2	1	2	1
5	6.06	5	5	4	4
6	9.69	2	2	1	1
7	7.75	3	3	3	3
Sheet12

Cell Formulas
Range	Formula
C2:C7	C2	=RANK(A2,$A$2:$A$16,0)+COUNTIF($A$2:A2,A2)-1
E2:E7	E2	=RANK(A2,($A$2:$A$7),0)

Which does not meet your needed criteria