![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilzC9Iz7Ew-D5_NATwymcf2Q0gz79dZlLRbmqv52b8uF56q5B30NCMi6MjA9NPa5CPIFYn1t-UblLqVkl_MCBvTNzJcZy3iKstLh3ATaqXEXp_kYgiRAiK9rSwhyYTVhltqISQ6AO6lYM/s320/605.jpg)
--------------------------------------------
Dates in column A Text in Column B
--------------------------------------------
03/10/2003 AAA
03/15/2003 BBB
03/20/2003 CCC
03/25/2003 AAA
03/30/2003 BBB
04/04/2003 CCC
03/25/2003 AAA
03/30/2003 BBB
04/04/2003 CCC
03/25/2003 AAA
03/30/2003 BBB
04/04/2003 CCC
Enter the formula : =A1&B1 to cell C1 and copy / paste the formula to cells C2:C12
Enter the formula : =IF(COUNTIF($C$1:C1,C1)>1,"Duplicate","Unique")
to cell E1 and copy / paste the formula to cells E2:E12
Dates in column A Text in Column B
--------------------------------------------
03/10/2003 AAA
03/15/2003 BBB
03/20/2003 CCC
03/25/2003 AAA
03/30/2003 BBB
04/04/2003 CCC
03/25/2003 AAA
03/30/2003 BBB
04/04/2003 CCC
03/25/2003 AAA
03/30/2003 BBB
04/04/2003 CCC
Enter the formula : =A1&B1 to cell C1 and copy / paste the formula to cells C2:C12
Enter the formula : =IF(COUNTIF($C$1:C1,C1)>1,"Duplicate","Unique")
to cell E1 and copy / paste the formula to cells E2:E12
No comments:
Post a Comment