WaqasTariq
Board Regular
- Joined
- Jun 26, 2012
- Messages
- 54
- Office Version
- 365
I am trying to find where the top 3 values in a range are stored. That part is done, however, if one or more of the top 3 have the same value, I only get the same cell locations and not the top 3.
Here is how my data looks like:
<tbody>
</tbody>
Formula I am using:
<tbody>
</tbody>
Result:
<tbody>
</tbody>
Result I want:
<tbody>
</tbody>
Where 8 is column H, 9 is column I and 10 is column J.
I will appreciate any help!
Here is how my data looks like:
A | B | C | D | E | F | G | H | I | J | ||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Formula I am using:
L | M | N |
=MATCH(LARGE(A1:J1,1),A1:J1,0) | =MATCH(LARGE(A1:J1,2),A1:J1,0) | =MATCH(LARGE(A1:J1,3),A1:J1,0) |
<tbody>
</tbody>
Result:
L | M | N |
8 | 8 | 8 |
<tbody>
</tbody>
Result I want:
L | M | N |
8 | 9 | 10 |
<tbody>
</tbody>
Where 8 is column H, 9 is column I and 10 is column J.
I will appreciate any help!