Return Text based on criteria

Hi All,

I am wondering if you all could help me.

I have a large database which has some other formula in it but I am having trouble in getting either "Primary" or "Secondary" value returned in Column C against each entry of column A "code" if its matches with the same date in a date column B. it would be great if i could have some of your thoughts on it.

OUTLET DATE Primary/ Secondary[/B]
1433079 21/06/2013 Secondary
1431970 01/08/2013 Primary
1431970 01/08/2013 Primary
1442690 21/06/2013 Primary
1432001 31/07/2013 Secondary
1433382 21/06/2013 Secondary
1434057 17/05/2013 Secondary
2591467 21/06/2013 Secondary
1442690 21/06/2013 Primary
1432040 01/08/2013 Secondary
1431970 01/08/2013 Primary
1432043 01/08/2013
1442407 21/06/2013
1432044 01/08/2013
1432051 31/07/2013
1432073 01/08/2013
1432092 01/08/2013
1432840 21/06/2013
1432840 17/05/2013
1432106 01/08/2013
1432115 01/08/2013
1442669 21/06/2013
1432123 01/08/2013


The sample sheet is attached for your reference.

Thank you in advance.

Shido

C2: =IF(COUNTIFS(A:A,A2,B:B,B2)=1,"Secondary","Primary")

copy down as far as needed

use the followIng formula In cell D2

HTML Code: 

use the followIng formula In cell C2

HTML Code: 

If It was really helpful to you then dont forget to hIt * button for user reputatIon.

Regards
CA Mahaveer SomanI

Thank you for your help Teethless mama. your code is simple and easy to understand. I appreciate your time and effort.

You're Welcome!