The formula is fine.

As its an array, you have to enter the formular ctrl=shift-enter

"AZExcelNewbie" wrote:

I have a vertical array which worked fine in another worksheet but does not
work now. It looks at a set of cells and sorts them from high to low,
currently it will find the highest number, but when you auto fill the cells
below it, it shows duplicate entries all the way down. Please let me know
what I'm doing wrong with the following formula:
=INDEX(A$2:A$76,MATCH(LARGE($B$2:$B$76-ROW($B$2:$B$76)/75^75,ROWS($A$2:A2)),$B$2:$B$76-ROW($B$2:$B$76)/75^75,0))

column 'a' contains names, column 'b' contains the number. There are 75
entries.