In A1 i have:
=INDEX(D2:D6,MATCH(LARGE(E2:E6,C2,E2:E6,FALSE))
This formula returns the top most valuable customer (dog). But there is a tie for second place (cat and amy) but it returns Amy Twice. How do i fix this? Ty
<tbody>
</tbody>
=INDEX(D2:D6,MATCH(LARGE(E2:E6,C2,E2:E6,FALSE))
This formula returns the top most valuable customer (dog). But there is a tie for second place (cat and amy) but it returns Amy Twice. How do i fix this? Ty
A | B | C | D | E |
Waffle | 90 | 1 | Dog | 30 |
Amy | 50 | 2 | Cat | 50 |
Amy | 50 | 3 | Amy | 50 |
Dog | 30 | 4 | Stick | 10 |
Stick | 5 | Waffle | 90 |
<tbody>
</tbody>
Last edited: