Small example of the columns:



ABCD 1
ABCD 1
ABCD 2
ABCD 0
DCBA 0
DCBA 1
DCBA 1
PPPP 0
PPPP 1
PPPP 2
PPPP 2
LLLL 0
LLLL 0
LLLL 1

I need end up with the rows only with the highest number in the last column, so it should look like this after:

ABCD 2
DCBA 1
DCBA 1
PPPP 2
PPPP 2
LLLL 1


I am sure this is some easy small code but I don't know where to start on this one really.... thanks!