lhs42
04-14-2005, 05:56 AM
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 B C D
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.
all thoughts appreciated - my brain's run out of ideas
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 B C D
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.
all thoughts appreciated - my brain's run out of ideas