Hello
I tried many combinations of formulas but every time first and second highest value is the same im getting first key for both.
DATA
<tbody>
</tbody>
Display
<tbody>
</tbody>
I tried many combinations of formulas but every time first and second highest value is the same im getting first key for both.
DATA
# | A | B | C |
1 | 1 | USER1 | 8 |
2 | 2 | USER1 | 8 |
3 | 3 | USER1 | 4 |
4 | 4 | USER2 | 5 |
<tbody>
</tbody>
Display
# | A | B |
1 | [find key [DATA A:A] of first highest value [DATA C:C] based on [Display B3] | USER1 |
2 | [find key [DATA A:A] of second highest value(even is the same as first one) [DATA C:C] based on [Display B3] | USER1 |
<tbody>
</tbody>