Hi

my spreadsheet holds project reports - each as a line item (about 1000)
i can do this manually but its clunky & relies on no human error (not good)

i want to produce a summary that shows latest report for current projects and also projects failing to report - esentially a show"n"tell
something like this
a 14/11/2005 2 current
c no return 0 current
d 13/12/2004 23 current

from a list like this
project date result status
a 01/12/2004 90 current
a 26/02/2005 3 current
b 24/05/2005 23 not live
b 19/08/2005 98 not live
a 14/11/2005 2 current
c no return 0 current
d 13/12/2004 23 current


i've made a pivot table which pretty much does the job. but i cant figure out how to get it to only show the latest report for a project. it lists them all - i then go through & delete the old ones. its clunky & subject to error.


please please help - this is becoming the bane of my life as my projects list is growing like brushfire.