Thread: how do i set up if cell content repeat, warn given
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default how do i set up if cell content repeat, warn given
Typically, you use Countif. If data is entered in a1, and you don't want it
to be a duplicate of anything in column B, use:

=if(countif(b:b,a1)0,"Duplicate","OK")

Regards,
Fred.

"lahiripranab" wrote in message
...


Reply With QuoteReply With Quote