Otherwise, if, for example, 100 Jan is meant to be different to 100 Feb
then enter in cell C2:
=A2&B2
and enter in cell D2:
=IF(COUNTIF($C$2:C2,C2)=1,"Unique","")

Copy these formulae down and hide column C if desired.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531468