Isolating last line from a group. VBA?

I use sort then subtotal and I get a great list of the sorted fields seperated by a "total " line. But how do I isolate the line before the "Total for..." line.
I can do it by an "=if(f10=0,0,1) then sorting by the new column, but its tedius and not automatable.

Example:

a 1/12/08
a 1/15/08
a 2/10/08
total for a 3
b 1/13/08
b 2/14/08
total for b 2
...


I would like to cut this to:
a 2/10/08
b 2/14/08


Is there another solution to this issue? maybe VBA?

Hi

Not sure I follow.

Do you really want to extract a list of the largest dates for each of the grouping items and place them somewhere else?

Or do you really want to delete all the rows except for the largest date in each group???


rylo

Rylo,
I just want to remove all the lines except the one with the latest date from each group.

Colofnature,
I will try it, thanks.