Before compile the data is:
IP user name Hits
x A 10
y A 1000
Z A 20
L B 2000
M B 10
N B 500

After compile the data is:
IP user name Hits
y A 1000
L B 2000

are there any script can choose the username (Column B) base on the highest
hits at columns C. Thank you..