how to avoid duplicates in excel workbook?

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

Hi,

Thus link is quite good for duplicate testing etc.

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

Thanks a lot,
Hari
India

"smart" <[email protected]> wrote in message
news:[email protected]...
> 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
>