compare dates using 2 conditions

Appreciate if someone could help me here.
I need to do a test against an ID to see if a date is greater than another date based on a 'type' indicator.

For example:

ID Date Type
1 31/01/2011 I
1 31/01/2011 A
1 31/12/2011 A
1 31/12/2011 C

The test is: If date of ID 1 Type C is > date of ID 1 of Type I return a yes, otherwise return no. In this case the answer would be Yes.

Example workbook attached. I have to do this with 1000 different records hence the need for a formula approach, which I don't how to do.

Thanks