Thread: Is there a formula that can spot duplicate reference des's
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Is there a formula that can spot duplicate reference des's
=IF(COUNTIF($A$2:A2,A2)1,"Duplicated","")

"Michaela" wrote:

I need a formula that will spot duplicate reference diesignator's such as if
you have mo9310 more than once, the cell will say ref! or change color.
Reply With QuoteReply With Quote