R
Rowland
I use this formula
MATCH(LARGE(J$1:J$55,ROW()),J$1:J$55,0
It returns the row numbers which translates to the largest number in the
range large to small
Problem is if there numbers in the range which are duplicates,it will
return the same row number ,I need it to return the row number +1
A1 5 2
A2 6 1
A3 4 4
A4 3 3
A5 3 4 <<<<< should be 5
MATCH(LARGE(J$1:J$55,ROW()),J$1:J$55,0
It returns the row numbers which translates to the largest number in the
range large to small
Problem is if there numbers in the range which are duplicates,it will
return the same row number ,I need it to return the row number +1
A1 5 2
A2 6 1
A3 4 4
A4 3 3
A5 3 4 <<<<< should be 5