name Draft1 Draft2 DAte
YAN 13.8 1 31-DEC-12 10.59.06AM
YAN 13.8 13.8 24-DEC-12 09.13.06AM
YAN 13.8 13.8 22-DEC-12 11.43.49AM
YAN 13.8 13.8 21-DEC-12 12.04.40PM
AB 10.8 13.8 21-DEC-12 02.23.58PM
AB 12.8 13.8 19-DEC-12 05.42.08PM
AB 9.8 13.8 17-DEC-12 11.28.58AM
HD 13.8 13.8 13-DEC-12 08.59.44AM
HD 17.8 15.8 10-DEC-12 02.05.49PM
AN 19.8 19.8 24-DEC-12 09.28.32AM
AN 1.8 1.8 21-DEC-12 02.28.49PM
AN 13.8 13 17-DEC-12 11.48.55AM
AN 1.8 3.8 10-DEC-12 02.03.42PM

hi people how can i select values of draft 1 and 2 based on the latest date for each of the name
e.g my desired outcome will be
YAN 13.8 1 31-DEC-12 10.59.06AM
AB 10.8 13.8 21-DEC-12 02.23.58PM
HD 13.8 13.8 13-DEC-12 08.59.44AM
AN 19.8 19.8 24-DEC-12 09.28.32AM
thanks !