Hi,

i have data like following, which is the salesman responsible for each state
until a specific time:

David - CA - 2008/1/12
Peter - NY - 2008/5/25
Susan - CA - 2009/3/25
David - NY - 2008/4/20

How do I search "CA" and it will show latest records for each salesman has
been working in CA, ie,

David - CA - 2008/1/12
Susan - CA - 2009/3/25