Ranking numbers challenge

[morsagmon]

Hi.

I have a column of numbers:
23
13
23
7
25
25
19
23
8

I need to rank these numbers in an adjacent column, smallest to largest, with duplicate values sub-ranked. The result column for the above list would be:
5
3
6
1
8
9
4
7
2

I can use helper columns as needed.
Can't come up with the correct formulas...

Thanks!
Mor

 

[Jonmo1]

Welcome to the board.

Try this in B1, assuming numbers start in A1.

=RANK(A1,$A$1:$A$9,1)+COUNTIF($A$1:$A1,$A1)-1

 

[morsagmon]

Welcome to the board.

Try this in B1, assuming numbers start in A1.

=RANK(A1,$A$1:$A$9,1)+COUNTIF($A$1:$A1,$A1)-1

Yessssss!
Many thanks, Jonmo1 !

 

[Jonmo1]

You're welcome.