Formula that receives array as input and gives ranking as output

[ORoxo]

[FONT=&quot]Hello, everyone,[/FONT]
[FONT=&quot]I'm looking for a formula which when inserted in a SINGLE cell would return {1,2,3,4,5,6} for the array below


[/FONT]
[TABLE="width: 500"]
<tbody>[TR]
[TD]55[/TD]
[/TR]
[TR]
[TD]45[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]21[/TD]
[/TR]
[TR]
[TD]21[/TD]
[/TR]
[TR]
[TD]21[/TD]
[/TR]
</tbody>[/TABLE]

[FONT=&quot]I tried the formula below, but it doesn't deal well with duplicates:[/FONT]
[FONT=&quot]
[/FONT]

=rank(A2:A7,A2:A7)

Thanks!

Kind regards,
ORoxo

 

[StephenCrump]

Perhaps:

=RANK.EQ(A2:A7,A2:A7)+COUNTIF((INDIRECT(ADDRESS(ROW(A2),COLUMN(A2))&":"&ADDRESS(ROW(INDIRECT(ROW(A2)&":"&ROW(A2)+ROWS(A2:A7)-1)),COLUMN(A2)))),A2:A7)-1