View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rowland Rowland is offline
external usenet poster
 
Posts: 18
Default match and large fumction

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