Differentiate Maximum value

[Sathisc]

Hi,

I have the data a give in the table. I need a formula to differentiate the maximum value to each names updated in column A

User	Percentage
Satz	20
Satz	80
Eliy	70
Eliy	30
Shar	90
Shar	10
Vin	40
Vin	60

<colgroup><col width="64" style="width: 48pt;" span="2"><tbody>
</tbody>

I need formula to highlight or differentiate in another column the max vaue(satz 80 should be highlighted or some differentiation required)

Thanks,
Sathish

 

[Phuoc]

Try this formula for CF:

=$B1=MAX(($A$1:$A$8=$A1)*$B$1:$B$8)

 

[Sathisc]

Thanks you for your reply.
for eg: I need Satz to get compared in column A and the MAX value in B column need to be differentiated.