Bob Phillips wrote:
=MATCH(LARGE(J$1:J$55,ROW()),J$1:J$55,0)+COUNTIF($ J$1:$J1,J1)-1


The range is the first column,the formula in the second column dragged
down is MATCH(LARGE(M$1:M$55,ROW()),M$1:M$55,0)(it must start in the
first row)

26 is returned because its the row number of 112 (the highest number in
the range)

I should have 55 unique numbers in the second column with no
duplicates?I don't because there are duplicates in the first column.


85 26
98 35
91 42
92 45
103 19
97 5
87 5
95 16
101 16
98 9
82 43
93 27
91 27
94 27
98 2
102 2
95 2
83 2
104 2
94 6
78 6
98 6
83 8
91 8
79 14
112 14
99 14
90 12
87 4
94 4
90 3
97 3
83 3
98 3
110 3
90 28
91 28
91 28
99 7
103 7
102 1
107 46
100 18
92 18
106 18
84 11
80 47
99 25
97 21
56 50
37 52
38 51
31 53
20 54
15 55