I'm not sure what your purpose is, so here are 3 alternatives:
Alt 1: Count the number of 'non single items'
=SUMPRODUCT((COUNTIF(A5:A13,A5:A13)1)/2)
Alt 2: Menu: FormatConditional Formatting
=COUNTIF($A$5:$A$13,A5)1
Insert in A5 (here) and then Copy and Paste format
Alt 3: Menu: DataValidation
Mark the whole area from A5 to A13 (here), then insert this formula
=COUNTIF($A$5:$A$13,A5)=1
Hope this helps
Ola Sandström
Enclosed zip-file:
http://www.excelforum.com/attachment...tid=3515&stc=1
+-------------------------------------------------------------------+
|Filename: Book5.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3515 |
+-------------------------------------------------------------------+
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=380395