=MATCH(LARGE(J$1:J$55,ROW()),J$1:J$55,0)+COUNTIF($ J$1:$J1,J1)-1
works with the original list, but not with this:
5
6
4
3
3
1
1
2
5
1
9
5
9
7
7
8
4
9
=MATCH(LARGE(J$1:J$55,ROW()),J$1:J$55,0)
works if a small number, say RAND()/10000,
is added to all the numbers with
Copy Paste Special Add
Duplicate numbers will have different row references,
but not necessarily in increasing order.
The results might look like this:
11
18
13
16
14
15
2
1
12
9
17
3
4
5
8
7
10
6