Return Text based on criteria

Hi All,

Referring to the original post http://www.excelforum.com/excel-form...-criteria.html, there is a small addition to a condition shared earlier.

I want to use the formula which return at first "primary" and than "secondary" if the outlet has two or more same date, like 1431970. For the rest of outlet, if not have same date, it return "Primary".

OUTLET TBC DATE Primary/ Secondary
1431970 01/08/2013 Primary
1431970 01/08/2013 Secondary
1431970 01/08/2013 Secondary
1432001 31/07/2013 Primary
1433382 21/06/2013 Primary
1434057 17/05/2013 Primary
1442690 21/06/2013 Secondary
1432040 01/08/2013 Primary
1431970 01/08/2013 Secondary
1432043 01/08/2013 Primary
1432043 01/08/2013 Secondary
1432051 31/07/2013
1432073 01/08/2013
1432092 01/08/2013

Hope you got my point.

Thank you again

Shido

Thank you for both of your help. it was simple which i couldn't think of but you made my problem solved. Thanks once again.. cheers