Q
quailhunter
I have an interesting situation in an Excel spreadsheet and I was
wondering if there's a way to handle this?
I'm looking to return the top 5 scores, and the person's name
associated with the score. The problem is, when I use the INDEX MATCH
function, I always return the same person if there is more than one
individual with exactly the same score.
=INDEX(A1:A5,MATCH(LARGE(B1:B5,1),B1:B5,0))
Johnson 154
Alberts 160
Smith 154
Able 120
Reese 110
If I change the '1' in the LARGE function to 2, then to 3... It returns
Alberts, then Johnson, then Johnson again... So, it's only finding the
first occurrence of Johnson and not returning Smith for '3'...
Is there anyway to code this problem so I'd return Alberts, Johnson,
Smith???
wondering if there's a way to handle this?
I'm looking to return the top 5 scores, and the person's name
associated with the score. The problem is, when I use the INDEX MATCH
function, I always return the same person if there is more than one
individual with exactly the same score.
=INDEX(A1:A5,MATCH(LARGE(B1:B5,1),B1:B5,0))
Johnson 154
Alberts 160
Smith 154
Able 120
Reese 110
If I change the '1' in the LARGE function to 2, then to 3... It returns
Alberts, then Johnson, then Johnson again... So, it's only finding the
first occurrence of Johnson and not returning Smith for '3'...
Is there anyway to code this problem so I'd return Alberts, Johnson,
Smith???