I have the following table

A-------B
apple 23
apple 20
apple 21
apple 15
peach 23
peach 15
peach 21
orange 7
orange 8
orange 12
orange 15
orange 23
orange 30
orange 25
orange 21
orange 14

I want to check the value in a An is available in Column A and if it is repeated then take the max value from Column B for the repeated cells
this list will be changed periodically