Thread: Finding repeated data in adjacent cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
kraljb kraljb is offline
external usenet poster
  
Posts: 1
Default Finding repeated data in adjacent cells

Say that the values you want to check for duplicates in is in Column A.
In column B have this formula
=IF(COUNTIF($A$1:$A$1000,A1)1,"DUPLICATE","")


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=560855

Reply With QuoteReply With Quote