Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
Is there a way MATCH() can cope with duplicate values? | Excel Worksheet Functions | |||
Large Index Match Lookup | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions |