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

[TABLE="width: 96"]
<colgroup><col width="64" style="width: 48pt;" span="2"><tbody>[TR]
[TD="width: 64, bgcolor: transparent, align: center"]User
[/TD]
[TD="width: 64, bgcolor: transparent, align: center"]Percentage[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]Satz
[/TD]
[TD="bgcolor: transparent, align: center"]20[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]Satz[/TD]
[TD="bgcolor: transparent, align: center"]80[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]Eliy[/TD]
[TD="bgcolor: transparent, align: center"]70[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]Eliy[/TD]
[TD="bgcolor: transparent, align: center"]30[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]Shar[/TD]
[TD="bgcolor: transparent, align: center"]90
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]Shar[/TD]
[TD="bgcolor: transparent, align: center"]10[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]Vin[/TD]
[TD="bgcolor: transparent, align: center"]40[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]Vin[/TD]
[TD="bgcolor: transparent, align: center"]60[/TD]
[/TR]
</tbody>[/TABLE]

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.