S
stan
Hello,
I'm using the following formula but am running into an issue.
INDEX(Data!$A$12:$A$1314,MATCH(LARGE(OFFSET(Data!$T$12:$T$1314,0,0),1),OFFSET(Data!$T$12:$T$1314,0,0),0))
When trying to find the n-th largest value multiple entries have the same
value so they are all the n-th largest value. Therefore the list comes up
with one name being entered as, for example, the 4th, 5th, and 6th largest.
Any suggestions on how to fix this?
Thank you!
I'm using the following formula but am running into an issue.
INDEX(Data!$A$12:$A$1314,MATCH(LARGE(OFFSET(Data!$T$12:$T$1314,0,0),1),OFFSET(Data!$T$12:$T$1314,0,0),0))
When trying to find the n-th largest value multiple entries have the same
value so they are all the n-th largest value. Therefore the list comes up
with one name being entered as, for example, the 4th, 5th, and 6th largest.
Any suggestions on how to fix this?
Thank you!