how to find highest value from 2 collumn

[gregoriusaryant]

hello.... i have problem how to find highest value from 2  or 3 column like this

      row      Date      name       attempt

•     11/14/2023  name a    2
•     11/14/2023  name b    2
•     11/14/2023  name c    2
•     11/12/2023  name  b   1
•     11/10/2023  name a    1

what would i want is get highest value in attempt column based on / refference by name.

can anyone help me with the formula?

big thanks.