Rank , with duplicates

[ste33uka]

Is there any way to rank the follwing example so points would be what i have wrote in columns D.
Thanks

Book2.xlsx
	A	B	C	D
1
2
3
4	90%		11	11
5
6
7
8	80%		10	10
9
10
11
12	70%		9	9
13
14
15
16	60%		4	8
17
18
19
20	60%		4	8
21
22
23
24	60%		4	8
25
26
27
28	60%		4	8
29
30
31
32	60%		4	8
33
34
35
36	50%		3	7
37
38
39
40	40%		2	6
41
42
43
44	30%		1	5
Sheet1

Cell Formulas
Range	Formula
C4,C44,C40,C36,C32,C28,C24,C20,C16,C12,C8	C4	=RANK(A4,(A$4,A$8,A$12,A$16,A$20,A$24,A$28,A$32,A$36,A$40,A$44),1)

 

[mole999]

i would use A and D on a seperate sheet, then INDEX / MATCH or VLOOKUP to return what you want to see