Sort Data According to latest date and lowest balance. Excel 2007

Sample Data:

ID # Date Balance
3605944 2/15/2012 15:20 $1.19
3605944 2/15/2012 15:20 $2.19
3605944 2/15/2012 15:21 $3.19
3605944 2/15/2012 15:21 $2.94
3605944 2/15/2012 15:21 $2.69
3605972 2/12/2012 9:05 $10.42
3605972 2/13/2012 9:05 $9.42
3605972 2/14/2012 9:05 $8.42
3605981 2/14/2012 10:58 $1.07
3605981 2/14/2012 10:58 $0.82
3605981 2/14/2012 10:58 $0.57
3605981 2/14/2012 10:59 $0.32
3605981 2/14/2012 10:59 $0.07



How do I format the data so that only the latest date is left over with it's respective (lowest) balance and card number.?
So that I would end up with the data below.

3605944 2/15/2012 15:21 $2.69
3605972 2/14/2012 9:05 $8.42
3605981 2/14/2012 10:59 $0.07