Database Functions
 

I am using a table w/ the following data in columns A - C:

Prospect Name Week Created Status
1 11/6/06 Open
2 11/6/06 Open
3 11/6/06 Open
4 11/6/06 Open
5 11/6/06 Open
2 11/13/06 Open
5 11/13/06 Closed
6 11/13/06 Open
7 11/13/06 Open
8 11/13/06 Open

Each week I add five names to the list. As you can see some of those names
are repeats from the previous week (e.g., "2" & "5"). Is there a database
function that will tell me which names fell off the list from week to week
(e.g."1", "3" & "4") and which were added (e.g. "6", "7", "8")?

Also, is there a LOOKUP type function that will refer to the most recent
occurence of a "Prospect Name" and return the "Status" (e.g. a search for "5"
would result in "Closed"?

Thank you in advance for your assistance