Hi,

In column A I have a list of values, of which there may be duplicates. I am using the LARGE() function to return the name - in column B - associated with the nth largest value.

A problem with using the LARGE() function on its own is that it only considers the first value that it encounters when there are more than one instance of that value. Can someone please tell me how to amend the LARGE() function to take account of duplications?

Thanks!