how do i set up if cell content repeat, warn given
 

how do i set up if cell content repeat, warn given
 

You mean like duplicate entries in a column?

You may want to look at Chip Pearson's site. He has lots of techniques to work
with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx

lahiripranab wrote:

--

Dave Peterson

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
...