Select last record for each account

[Gordon]

Hi all,

I have an excel file with the following format:

Account Date Amount
00110 1/20/2005 120.51
00110 6/2/2005 87.01
00110 8/15/2005 255.09
02055 2/5/2005 70.05
02055 4/1/2005 192.88
15240 2/20/2005 457.18
15240 9/21/2005 19.77
.... and so on.
The file has 12000 entries for over 500 different accounts.

I would like to select the entries for each account with the latest
date.

How do I do this?

Thanks,

Gordon

 

[Gordon]

Got it.

Use Subtotal function.