[h=2][/h]
I've searched and found some things that are similar, but not exactly what I want (i.e. Index/Match). I want to look up the 1st largest value and return what is in column A. I'm then repeating for the 2nd, 3rd, etc.
Here is the formula I have, but the output for the largest and 2nd largest are the same. I need the formula to be able to identify each uniquely.
=INDEX(A$1:A$14,MATCH(LARGE(B$1:B$14,ROWS($1:1)),B$1:B$14,0))
<tbody>
</tbody>
Largest word 4
2nd Largest word 8
3rd Largest word 14
Here is the formula I have, but the output for the largest and 2nd largest are the same. I need the formula to be able to identify each uniquely.
=INDEX(A$1:A$14,MATCH(LARGE(B$1:B$14,ROWS($1:1)),B$1:B$14,0))
Column A | Column B |
word 1 | 0 |
word 2 | 0 |
word 3 | 7 |
word 4 | 46 |
word 5 | 0 |
word 6 | 0 |
word 7 | 0 |
word 8 | 46 |
word 9 | 0 |
word 10 | 0 |
word 11 | 0 |
word 12 | 0 |
word 13 | 0 |
word 14 | 18 |
<tbody>
</tbody>
Largest word 4
2nd Largest word 8
3rd Largest word 14