Assuming your data is in column A from cell A1 downwards,

in B1 enter

=IF(COUNTIF(A$1:A$8,A1)2,"More than two "&A1,"")

using CTRL/Shift/Enter to enter an array formula, then formula-drag
this to the bottom of your data.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390147