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

**Bruce2000** · 02-19-2012, 02:41 PM

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

**arlu1201** · 02-20-2012, 03:53 AM

Should the output be provided in the same sheet or different sheet?

**JieJenn** · 02-20-2012, 04:30 AM

Hopefully this is what you're looking for

Please Login or Register  to view this content.

**Winon** · 02-21-2012, 07:14 AM

Hello JieJenn,

What an outstanding piece of work! I also had the problem solved, but my Macro takes very long to do what your one does in an instant.

I was so impressed with what you have done, that I added a few changes to your Macro, which in my opinion makes your work just so much better!

Please have a look at it (WorkBook attached), and let me know if you agree.

I think that Bruce2000 will be blown away, and give you a good rep!!!

**JieJenn** · 02-21-2012, 12:46 PM

Hey Winon, yours looks good. Only thing I would do differently is instead of using sheet1 or sheet2, I would use worksheets("worksheet name") just so if a user add a new worksheet the macro will still use the correct worksheets for raw data.