how to avoid duplicates in excel workbook?

[Guest]

Hello,


Question: How to avoid duplication in excel workbook.Suppose if the name of
the company is (ABC Inc.)entered in one sheet, and while entering the same
company name(i.e. ABC Inc.) in other sheet, the excel should show a message
that the company name already exist in so and so sheet name.

Pls provide me the detailed answer along with the required tools to solve
the above problem.

Thanking You

 

[Hari]

Hi,

Thus link is quite good for duplicate testing etc.

http://cpearson.com/excel/duplicat.htm

Thanks a lot,
Hari
India