I've never used a pivot table, but the little bit I had read made me think it was the right tool for this job. Now that I'm trying to do it and reading more, I think I was wrong. Can this be done, or should I use some other tool?

I have a sheet with ~1000 lines. Each line lists a maintenance task that was done in the past year in Column D. Some tasks were done several times (monthly, for example). The completion date for each task is in Column C. I want to display only the line showing the last date each task was done. I don't want to see all the earlier instances of each task.

Thanks!
kevin