well then instead of counting "thing", count whatever is in column a

if(and(countif(a:a,a1)0,countif(b:b,a1)0,countif (c:c,a1)0,countif(c:c,a1)0),a1,"")

maybe in column e and copied down for the rows of data?

alternatively, a macro could do the same search


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=374133