Hello,
I have a table with columns
Name, Date, % Complete

I would like to grab the Name/Date combo with the last date. Then get the % complete.

My data could look like this

Name, date, %complete
a, 1-1-2012, 10%
b, 1-5-2012, 20%
a, 1-6-2012, 20%
b, 2-1-2012, 30%
c, 2-1-2012, 10%
a, 2-3-2012, 30%

so I would want to grab
b, 2-1-2012, 30%
c, 2-1-2012, 10%
a, 2-3-2012, 30%

I can create a pivot table with Name and max of date. That gives the Name/Date combo.
But then I cannot get the % complete.

anyone have ideas?

thanks