How to find the highest value based on a name
I am trying to build an integration wit a Zoho Survey where users can do a survey multiple times. They are recorded in a Zoho Sheet to calculate their score.
For example
Score
|
Name
|
16
|
John Doe
|
12
|
John Doe |
13
|
Pete Johnson |
14
|
John Doe |
10
|
Maria Kipling |
14
|
Maria Kipling |
For all users I would like to get the highest score, so I can use it in another formula.
How would I get the highest score based on the Name?
So these would be the results:
| Highest |
Nem |
| 16 |
John Doe |
| 13 |
Pete Johnson |
| 14 |
Maria Kipling |
Thanks