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>
A
B
C
D
E
Waffle
90
1
Dog
30
Amy
50
2
Cat
50
Amy
50
3
Amy
50...