This is one option:
=COUNTIF($A$4:$A$18,A4)1
copy down, and use a Autofilter to find all True
HTH
Ola Sandström
Picture encl.:
http://www.excelforum.com/attachment...tid=3498&stc=1
+-------------------------------------------------------------------+
|Filename: Clipboard01.jpg |
|Download:
http://www.excelforum.com/attachment.php?postid=3498 |
+-------------------------------------------------------------------+
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=379019