View Single Post
  #1   Report Post  
smart
 
Posts: n/a
Default 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