Pulling Unique Records

Hi,

I would like to get only the cust#'s with Year 2007 but do not have P code and no Year 2008.

Cust# ID# Code Year

1 123 P 2008

1 456 C 2007

2 789 C 2008

2 1011 C 2008

3 1112 C 2007

4 4567 P 2008

4 6571 C 2007

5 4526 C 2007

5 4389 C 2008

5 2231 C 2008

6 2215 C 2007

7 6789 C 2007

8 1594 C 2007

8 2586 C 2007

From the above table, results will be:

Cust# ID# Code Year

3 1112 C 2007

6 2215 C 2007

7 6789 C 2007

8 1594 C 2007

8 2586 C 2007

Any suggestion will be helpful.

Thanks!