formula

I have three columns:

Country Year Dummy
Algeria 1999
USA 2000
England 2001
Cameroon 2002
Cameroon 2002
Cameroon 2003

I need a formula for the "Dummy" column that assigns a 1 for Cameroon in 2002 and a zero for all other rows. So my table should look like:

Country Year Dummy
Algeria 1999 0
USA 2000 0
England 2001 0
Cameroon 2002 1
Cameroon 2002 1
Cameroon 2003 0

Can someone help me.

Thankyou

Chris

That works perfect.

Chris